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

144 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
convict14341098(None) 
convect143114481convect
convicts15337711convicts
concoct10312902concoct
conduct121411592conduct
confect143614272confect
confit113316402confi_t
conflict1547752conflict
conic95329792con_ic_
conics103920592con_ics
connect113515742connect
consist9316032consist
contact1144020682contact
convects153410992convects
convent123919412convent
convert123721472convert
convicted1746312convicted
convince1547362convince
reconvict1646082reconvict
cantic103920543cantic_
cheviot1546933cheviot
civic123412543c_ivic_
civics13397823c_ivics
clonic104914673clon_ic_
coact96130583co__act
coccic8298943coccic_
coedit9316243coedi_t
coenact11311803coenact
coerect11913353coerect
coexist1638583coexist
cognovit1444633cognovi_t
coinfect15276843coinfect
coinvent1348183coinvent
colic95726173co_lic_
colics104219903co_lics
collect113314593collect
comfit133112423comfi_t
comic114721813co_mic_
comics124015563co_mics
commit124016703commi_t
commixt20357623commixt
compact153712213compact
conceit113218073conceit
concent114422513concent
concept133314443concept
concert113325223concert
conch124620073con__ch
concise11314473concise
concocts1138633concocts
condign1147733condign
conduce12139233conduce
conducts13118713conducts
conduit10713083conduit
confects153110873confects
confide13310203confide
confine12315583confine
confirm1437363confirm
confits122811423confits
conflicts1644793conflicts
congest104618773congest
congii957363congi_i
congius103210073congius
coni65534803con_i__
conical11316203con_ical
conicity15411093con_icity
conies84338593con_ies
coniine9316803coniine
conin76232723con_i_n
conine84528553con_ine
coning94331823con_ing
conins84327233con_ins
conium10415313con_ium
conjoint17410373conjoint
conjunct1945483conjunct
conking143618453conking
connects123010563connects
conning103718753conning
connive1238993connive
conoid9818883conoi_d
conoids10813883conoids
consent93723113consent
consign1038773consign
consists10310593consists
consort91319903consort
constrict13711623constrict
consult92513633consult
contacts123215213contacts
content94326153content
contest93523233contest
context163913433context
contort91422343contort
contract122915633contract
convected1738783convected
convector1648083convector
convene123314323convene
convents132614603convents
converts133213553converts
convex18367743conv_ex
convey144610223conv_ey
conveys15308223conveys
convicting1847583convicting
conviction1748183conviction
convinced1745363convinced
convincer1645833convincer
convinces1647833convinces
convoke16207173convoke
convoy14348543conv_oy
convoys15267023convoys
coppice1537483coppice
copyist1439053copyist
cornice11612933cornice
correct11513983correct
corvet114626933corv_et
corvid12310473corvi_d
corvids1337683corvids
corvina12229503corvina
corvine122113643corvine
cosmic12410343cosmic_
cosmist11311333cosmist
covert114925503co_vert
covet105638943co_v_et
covin105621123co_vi_n
coving124321523co_ving
covins114618063co_vins
cowlick1835263cowlick
crevice1436153crevice
cynic124712423cyn_ic_
cynics13377363cyn_ics
evict104417143__evict
iconic10411593icon_ic_
indict93115573_indict
ionic74622663ion_ic_
ionics84214483ion_ics
monist84324983mon_ist
nonfact1248893nonfact
novice1138433no_vice
ontic74418573_ontic_
reconvicts1744383reconvicts
sonic75225293son_ic_
sonics84315633son_ics
soviet9720153so_viet
tonic74727653ton_ic_
tonics83617863ton_ics
yonic105920843yon_ic_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271446.61020276.4
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.06225303.2
 
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.