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

242 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
complier1431025(None) 
comelier12310651comelier
compiler1438371compiler
complied1539671complied
compliers1538291compliers
complies14314521complies
campier133313272camp_ier
coalier93416172co_alier
collier93618152co_llier
comfier1439162com_fier
comparer143611362comparer
compeer133811552comp_eer
compeller1546292compeller
compile13312442compile_
compiled1537812compiled
compilers1537052compilers
compiles14311982compiles
complainer1645692complainer
completer153310412completer
complex2037242compl_ex
complexer22316202complexer
complice1639332complice
complices1739252complices
complin13312072compli_n
compline14313552compline
complines15312832complines
complins14313102complins
composer145012952composer
computer144511502computer
copier103722892co_p_ier
costlier1038522costlier
coupler114713012coupl_er
crumplier1543782crumplier
dimplier1336672dimplier
homelier1338982homelier
pimplier1445412pimplier
rumplier1235302rumplier
ampler104313303_ampl_er
applier1137903_applier
bumpier13359203bump_ier
cameleer1246033cameleer
camper124722213camp__er
campfire1744023campfire
camphire1745893camphire
cavalier1348173cavalier
chillier13328423chillier
chippier17297673chippier
chomper163810073chomp__er
choppier17286643choppier
clumpier1435583clump_ier
coaler84121703co_al_er
cobbier133410163co_bbier
cobbler133311823cobbl_er
cockier154013623co_ckier
coddler113710823coddl_er
codifier1447153codifier
coholder1436063coholder
coiler84421593co_il_er
colder95121833co__lder
colies84837053co__lies
collider113410413co_llider
collie83621993co_llie_
collied103316673co_llied
colliers103613583co_lliers
colliery13307363co_lliery
collies94326583co_llies
colter84625093co__lter
comaker153410603com_aker
combater1439373combater
comber125118503com__ber
combiner14259723combiner
comblike1846293comblike
comedies13311833comedies
comeliest13410033comeliest
comelily1546693comelily
comember1644163comember
comer95832693com___er
comether1537253comether
comities12317783comities
commie124215523com_mie_
commies133718443com_mies
commoner142710633commoner
communer14349293communer
commuter143010133commuter
compacter17257883compacter
compadre15295883compadre
companied1648023companied
companies15311793companies
compare135814993compare_
compared153811823compared
comparers15319383comparers
compares143816433compares
comped135919873comp__ed
compeers143410013comp_eers
compel124412893comp__el
compelled1646133compelled
compellers1645193compellers
compere134616623comp__ere
compered153414923compered
comperes143217973comperes
compete134716553compete_
competed154113593competed
competes144117243competes
compiling1637763compiling
comping143518593comp_ing
complain1448753complain
complained17175793complained
complainers1744473complainers
complains1549173complains
complaint15410243complaint
compleat14710153compleat
complect1659013complect
complete143412053complete
completed162810263completed
completers16298323completers
completes153212923completes
complexed23295963complexed
complexes22308093complexes
compliant1549663compliant
complicit1747433complicit
compliment1848403compliment
complot13310683compl_ot
complots1438163complots
comply152810383compl__y
complying1936113complying
compone136517193compone_
compose135716663compose_
composed154612063composed
composers153910613composers
composes145017113composes
composter15369563composter
compote135616463compote_
compotes144716513compotes
comprise14310813comprise
comprised1648053comprised
comprises15510943comprises
comprize2368733comprize
comprized2567223comprized
comprizes2468943comprizes
compted143813523comp_ted
compting153013603compting
compute134513653compute_
computed154110943computed
computers15339733computers
computes143914533computes
cooler84824713co_ol_er
coolie83821603co_olie_
coolies93824963co_olies
cooper104221123coop__er
coper95336093co_p__er
copied114618563co_p_ied
copiers114215963co_p_iers
copies104130303co_p_ies
copper124321893co_p_per
copter109822013co_p_ter
corkier133114303co_rkier
cornier93017083co_rnier
coruler9311713corul_er
cosier84423753co__sier
cottier93814173co_ttier
coulter94115593co_ulter
couple104415963coupl_e_
coupled124312673coupl_ed
couplers123311313coupl_ers
couples115317053coupl_es
couplet114717943coupl_et
coupling13310783coupling
courier93617873co_urier
courtier1059313courtier
courtlier1154453courtlier
couthier13218903couthier
cowier113616163co__wier
cowpie133511513cowp_ie_
cowpies143314283cowp_ies
cozier173315143co__zier
crampier14288903cramp_ier
crappier14288133crappier
crawlier13216873crawlier
crepier1139733crep_ier
crimpier14287323crimp_ier
croupier1246883croup_ier
crumblier1543873crumblier
cuddlier1234013cuddlier
cuppier1368323c_uppier
curlier93314183c_urlier
dopier93515923do_p_ier
dumpier12409653dump_ier
emptier1187603_emptier
gimpier12247933gimp_ier
godlier938893go_dlier
gogglier1153923gogglier
goodlier1035793goodlier
goopier103910573goop_ier
hempier14319003hemp_ier
holier94921623ho__lier
homier116416993hom__ier
homilies132710113homilies
hoppier143110703ho_ppier
hotelier1137633hotelier
humpier143110723hump_ier
implied1238613_implied
implies11312113_implies
jollier142911003jo_llier
jowlier17327563jo_wlier
jumpier18317943jump_ier
limpsier1234433limpsier
lonelier838003lonelier
loopier93711193loop_ier
loppier11369723lo_ppier
lordlier935353lordlier
loudlier934943loudlier
lovelier1136433lovelier
lowlier10338903lo_wlier
lumpier113410143lump_ier
mopier103914783mo_p_ier
motlier92010583mo_tlier
oilier64417233_o_ilier
outlier72216143_outlier
plier75221283___plier
portlier1038373portlier
replier94214973_replier
ripplier1234463ripplier
roilier7311523ro_ilier
romper104213683romp__er
ropier84118803ro_p_ier
roupier9319493roup_ier
sampler113212013sampl_er
simpler112910863simpl_er
soapier93411713soap_ier
sommelier1343643sommelier
soppier112711583so_ppier
soupier93111753soup_ier
supplier1246603supplier
timelier1036713timelier
vampier14308233vamp_ier
wamblier15275733wamblier
wimpier14248043wimp_ier
wobblier15325203wobblier
womanlier1443323womanlier
wombier1436533wom_bier
woolier103612353wo_olier
woollier1155433woollier

Search took 10 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.1731032896.0
2DLD Change Limit1461622429.03016186.3
3Display Results2422420.0962520.8
 (SQL Overall)1786912429.29919216.2
 
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.