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

147 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
complete14341205(None) 
compete134716551comp_ete
completed162810261completed
completer153310411completer
completes153212921completes
compere134616622comp_ere
competed154113592comp_eted
competes144117242comp_etes
compleat14710152compleat
complect1659012complect
complected19295862complected
complects1766412complects
completely1944542completely
completers16298322completers
completest16297872completest
completive1946232completive
complex2037242comple_x
complexed23295972complexed
complexer22316202complexer
complexes22308092complexes
complice1639332complice
compline14313552compline
complot13310682complot_
complots1438162complots
compote135616462comp_ote
compute134513662comp_ute
couplet114717942couplet_
couplets12389872couplets
incomplete1664262incomplete
bolete8519613bo__lete
bomblet13412263bomblet_
bomblets1436023bomblets
camlet104426583cam_let_
camlets114314623cam_lets
camphene1746613camphene
campsite1447413campsite
caplet104226813c_aplet_
caplets114914523c_aplets
champleve2141853champleve
chaplet14512253chaplet_
chapleted1743963chapleted
chaplets1556883chaplets
cochleae1544643cochleae
cochleate1645683cochleate
codpiece1544063codpiece
collate92919683co_llate
college102410443co_llege
collet84030363co_llet_
colleted113011663co_lleted
collets93517903co_llets
comate104124843com__ate
comblike1846293comblike
comet95946073com__et_
cometh134811683com__eth
comets105823583com__ets
commute134310443com_mute
compact153712213compact_
compacted18297363compacted
compacter17257883compacter
compacts16368903compacts
compadre15295883compadre
compare135814993comp_are
compart134016003compart_
comparted16338423comparted
comparts144210833comparts
comped135919873comp_e_d
compeer133811553comp_eer
compeered1646303compeered
compeers143410013compeers
compel124412893comp_e_l
compelled1646133compelled
compeller1546293compeller
compels133210883comp_els
compend144010303comp_end
compered153414923comp_ered
comperes143217973comp_eres
competent15411253comp_etent
compile13312443comp_ile
compiled1537813compile_d
compiler1438373compile_r
compilers1537053compilers
compiles14311983compile_s
complain1448763complain
complement18510103complement
completing1748423completing
completion1647303completion
complexest23265583complexest
complexity2653423complexity
complexly2543053complexly
complicate1847623complicate
complices1739253complices
complied1539673complied
complier14310253complier
compliers1538293compliers
complies14314523complies
complin13312073compl_in
complines15312833complines
complins14313113complins
complotted1743733complotted
comply152810383compl__y
compone136517193comp_one
comport133616843comport_
comported16319533comported
comports143411983comports
compose135716663comp_ose
composite15410153composite
compost134515353compost_
composted16378813composted
composter15369563composter
composts144210913composts
compotes144716513compotes
compress1439053compress
comprise14310813comprise
comprize2368733comprize
compt116328223comp__t_
compted143813523compte_d
compts125216653comp__ts
computed154110953computed
computer144511513computer
computes143914553computes
comte96125473com___te
concrete12411083concrete
conflate13311173conflate
coplot10518273co_plot_
coplots11511593co_plots
copulate122614113copulate
corelate10516013corelate
corslet9318063corslet_
corslets1038273corslets
coulee8323513co_ule_e
couple104415963coupl__e
coupled124312673couple_d
coupler114713013couple_r
couplers123311323couplers
couples115317053couple_s
cumulate123110223cumulate
deplete103010413_deplete
hoplite12311073ho_plite
omelet8317073_omelet_
omelets938333_omelets
omelette1045223_omelette
replete92912983_replete
template1238433template
templet112712003templet_
templets12226143templets
toeplate1047613toeplate
uncompleted1853993uncompleted

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 Limit1461621477.06320694.0
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.28224538.7
 
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.