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 “convicts” 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.

121 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
convicts1533771(None) 
convects153410991convects
convict143410981convict_
concocts1138632concocts
conducts13118712conducts
confects153110872confects
confits122811422confi_ts
conflicts1644792conflicts
conics103920592con_ic_s
connects123010562connects
consists10310592consists
contacts123215212contacts
convect143114482convect_
convents132614602convents
converts133213552converts
convicted1746312convicted
convinces1647832convinces
reconvicts1744382reconvicts
cervices1537133cervices
cheviots1643783cheviots
civics13397823c_ivic_s
coacts105314333co__acts
codices12512583co_dices
coedits10310243coedi_ts
coenacts1246403coenacts
coerects1258543coerects
coexists1735653coexists
cognovits1543153cognovi_ts
coinfects16344573coinfects
coinvents1445663coinvents
colics104219903co_lic_s
collects12279783collects
comfits14328743comfi_ts
comics124015563co_mic_s
commits133812383commi_ts
compacts16368903compacts
conceits122813613conceits
concents122516603concents
concepts143110303concepts
concerts123016063concerts
conchs134714903con__chs
concoct10312903concoct_
conduces13129783conduces
conduct121411593conduct_
conduits111210063conduits
confect143614273confect_
confides14310573confides
confines13315653confines
confirms1536303confirms
confit113316403confi_t_
conflict1547753conflict_
congests113510383congests
congius103210073congi_us
congrats11311433congrats
conic95329793con_ic__
conical11316203con_ical
conicity15411093con_icity
conies84338593con_i_es
coniines10415363coniines
conines93827793con_ines
conins84327233con_i_ns
coniums11311863con_iums
conjuncts2043653conjuncts
connect113515743connect_
connives1339723connives
conoids10813883conoi_ds
consents102715893consents
consigns1137533consigns
consist9316033consist_
consorts101512343consorts
constricts1477733constricts
consults10219983consults
contact1144020683contact_
contents104018213contents
contests103413383contests
contexts17378653contexts
contorts101112643contorts
contracts132212013contracts
convected1738783convected
convector1648083convector
convectors1768313convectors
convenes132916913convenes
convent123919413convent_
convert123721473convert_
convexes20278273convexes
conveys15308223conv_eys
convicting1847583convicting
conviction1748183conviction
convictions1848043convictions
convince1547363convince
convinced1745363convinced
convincer1645833convincer
convincers1745063convincers
convokes17247703convokes
convoys15267023conv_oys
coppices1638243coppices
copyists1545993copyists
cornices12713293cornices
corrects1259573corrects
cortices12615013cortices
corvets124715023corv_ets
corvids1337683corvi_ds
corvinas13238013corvinas
cosmists1237993cosmists
coverts124813813co_verts
covets114819643co_v_ets
covings134511243co_vings
covins114618063co_vi_ns
cowlicks1944663cowlicks
crevices1536713crevices
cynics13377363cyn_ic_s
evicts11368553__evicts
indicts103210723_indicts
ionics84214483ion_ic_s
monists93614783mon_ists
nonfacts1346073nonfacts
novices1238223no_vices
reconvict1646083reconvict_
sonics84315633son_ic_s
soviets1087293so_viets
tonics83617863ton_ic_s

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621217.56319325.9
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.76523012.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.