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

124 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
continue1031112(None) 
continua1047651continua
continued1248481continued
continuer1148711continuer
continues11310991continues
continuo1047351continuo
confine12315582confin_e
coniine9316802coniin_e
conine84528552con_in_e
continual1147142continual
continuate1248332continuate
continuers1247952continuers
continuos1147002continuos
continuum1344132continuum
convince1547362convince
pontine92419052pontin_e
tontine72316142tontin_e
antinuke1246493_antinuke
antique1638883_antique
boutique1943283boutique
canine83826703can_in_e
canticle1239703canticle
cantina93417253cantin_a
cantinas102713783cantinas
canting104725903cantin_g
centiare1067203centiare
centile94217183centi_le
centime114513033centi_me
coating103525313coatin_g
coatings113811843coatings
cocaine111315173cocain_e
codeine103815033codein_e
combine133014723combin_e
comminute1596153comminute
conative131214623conati_ve
concise11314473conci_se
condense1179613condense
condone102616293condon_e
confide13310203confi_de
configure1544463configure
confined14310403confined
confiner13311193confiner
confines13315653confines
confiture1445953confiture
congius103210073congi_us
coniines10415363coniines
conin76232723con_in__
conines93827793con_ines
coning94331833con_in_g
conins84327233con_in_s
conium10415313con_i_um
conking143618453conkin_g
conning103718763connin_g
connive1238993conni_ve
conominee1348163conominee
consignee1246563consignee
constitute1276703constitute
constringe1345853constringe
construe1049053construe
contain9315833contain__
contained12310893contained
container11311073container
contains10316533contain_s
conte76633203cont___e
contend103511893conten_d
contended1339273contended
contender1239563contender
contends112810573contends
content94326153conten_t
contented12313043contented
contents104018213contents
continence1489133continence
continent11415633continent
contingent1349083contingent
continuance1555123continuance
continuant12128293continuant
continuing1348193continuing
continuity1545993continuity
continuous1245723continuous
continuums1453523continuums
contour939973cont_our
contribute1455473contribute
contrite10318543contrite
contrive13311353contrive
contuse9311413cont_use
convene123314323conven_e
convinced1745363convinced
convincer1645833convincer
convinces1647833convinces
coontie9311423coonti__e
cootie84223093cooti__e
copihue1444143co_pihue
coprince1447093coprince
cortin82423153cortin__
cortina91915973cortin_a
cortinas102212453cortinas
cortins92421333cortin_s
corvine122113643corvin_e
cosine83823513co_sin_e
costing104323023costin_g
costive12312843costi_ve
coting94629253co_tin_g
cotinga10348023co_tinga
cotinine10311493co_tinine
counting113115273countin_g
critique1943033critique
cystine1239333cystin_e
dentine83320243dentin_e
detinue85010033_detinue
discontinue1455243discontinue
fontina1038633fontin_a
fontinas1136853fontinas
intine61021983_intin_e
montane91313623montan_e
monticule1344713monticule
nontitle846943nontitle
online6315843_onlin_e
postique1945873postique
poutine93316823poutin_e
retinue75414843_retinue
routine72615903routin_e
sonatine8313323sonatin_e
tontines82114733tontines
wonting113214103wontin_g

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621247.90618487.5
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.37521336.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.