Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “consoling” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

156 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
consoling1231087(None) 
condoling13510371condoling
censoring1238782censoring
condoning1339782condoning
connoting12310022connoting
consolingly1753082consolingly
consorting13410742consorting
consulting1349082consulting
consuming1437912consuming
convoking1935742convoking
convolving1944412convolving
convoying1835982convoying
cooling103422572co__oling
counseling1345462counseling
reconsoling1444482reconsoling
bosoming1336643bo_soming
cajoling18318423c_ajoling
canaling112016413can_aling
canalling1239553canalling
canceling14310163canceling
candling122313873can_dling
cannoning1237323cannoning
canoeing11310213can_oeing
canoodling1443583canoodling
cantoning12310883cantoning
canyoning1536873canyoning
capsuling1444533capsuling
caroling113317003c_aroling
castling11311233c_astling
censing104215263cens__ing
censuring1237603censuring
censusing1244813censusing
chiseling1536403chiseling
coaling103722823co__aling
coasting113615513coas_ting
coastline1196363coastline
cobbling15248803co_bbling
cockling172310393co_ckling
cocooning1447023cocooning
coddling13258473co_ddling
codling114418953co__dling
coevolving1942353coevolving
coffling1736483co_ffling
cohosting1546323cohosting
coiling103723453co__iling
coinsuring1345373coinsuring
coloring11414843co_loring
commoving1944983commoving
compiling1637763compiling
composing16179843composing
concaving1737343concaving
concealing1549303concealing
conceding1559343conceding
concocting1448413concocting
condolent1249833condolent
conducing1537693conducing
confiding1638333confiding
confining1539993confining
conforming1847373conforming
confusing1537333confusing
confuting1539093confuting
congaing1239823con_gaing
congealing1447633congealing
congeeing1337903congeeing
conglobing1644093conglobing
coning94331823con___ing
conjoin1638203conjo_in_
conjoining2046103conjoining
conjoins1738133conjo_ins
conjoint17410373conjo_int
conjuring1937913conjuring
conking143618453con__king
conning103718753con__ning
conniving1537093conniving
consenting13313213consenting
conserving1639743conserving
consign1038773cons__ign
consigning1446783consigning
consisting1349523consisting
consol82614113consol___
console92715983consol__e
consoled112911443consol_ed
consoler102812613consol_er
consolers112510923consolers
consoles103216153consol_es
consols92914073consol__s
consonant11410163consonant
conspiring1546553conspiring
constringe1345843constringe
construing1347433construing
contorting13410103contorting
contouring1347013contouring
controlling1445423controlling
contusing1239143contusing
convening15311193convening
conveying1838323conveying
convoluting1744203convoluting
convulsing1645383convulsing
cooing94024923co__o_ing
cooking143818973co__oking
cooping123918933co__oping
corbeling1439033corbeling
cordoning1338063cordoning
cornrowing1643613cornrowing
corroding1337943corroding
corseting12312173corseting
coshing134316433co_s_hing
cosmoline1346183cosmoline
cosseting1239543cosseting
costing104323023co_s_ting
cosying134513133co_s_ying
cottoning1237343cottoning
counselings1442713counselings
counselling1444403counselling
coupling13310783co_upling
couponing1446293couponing
cowboying2043183cowboying
cowling134017413co__wling
ensiling9410723_ensiling
ensouling1046003_ensouling
fondling13189353fon_dling
fooling113117373fo__oling
gosling93312403go_s_ling
hanseling1338063hanseling
hondling132210013hon_dling
honoring12310473hon_oring
houseling1337483houseling
insouling1036823_insouling
jostling16207123jo_stling
morseling1238073morseling
noncling11310763non_cling
noncoding1347673noncoding
noncoking1646813noncoking
nonloving1345413nonloving
nonmoving1545103nonmoving
nonruling1046433nonruling
nonsaline948413nonsaline
nonsmoking1743713nonsmoking
nonsolid957403nonsoli_d
nonsolids1045373nonsolids
nonvoting1346903nonvoting
oncoming1338353_oncoming
ongoing938793_ongo_ing
poisoning1245903poisoning
pooling103219093po__oling
ransoming1256513ransoming
resoling92916303_resoling
snooling93013473_snooling
soling74226823___soling
sponsoring1343633sponsoring
tinseling1036643tinseling
tonsuring1046503tonsuring
tooling82918313to__oling
topsoiling1343223topsoiling
tousling938793tous_ling
unsling8313643_uns_ling

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.1701051123.5
2DLD Change Limit1486411568.50017487.2
3Display Results1561560.1431090.9
 (SQL Overall)1786911568.81320275.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.