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

206 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
compiler143837(None) 
compile13312441compile_
compiled1537811compiled
compilers1537051compilers
compiles14311981compiles
complier14310251complier
campier133313272campi_er
coiler84421592co__iler
combiner14259722combiner
comelier12310652comelier
comfier1439162comfi_er
comparer143611362comparer
compeer133811552comp_eer
compeller1546292compeller
complex2037242comp_lex
complied1539672complied
compliers1538292compliers
complies14314522complies
composer145012952composer
computer144511512computer
copier103722892co_pi_er
coupler114713012coup_ler
ampler104313303_amp_ler
boiler84319273bo__iler
bumpier13359203bumpi_er
camailed1336553camailed
camper124722213camp__er
campily1638273campil_y
caviler1249063c_aviler
ceiler84013963c__eiler
chapiter1536603chapiter
chomper163810073chomp__er
choppier17286643choppi_er
clumpier1435583clumpi_er
coaler84121713co__aler
coalier93416183coali_er
cobbier133410163cobbi_er
cobbler133311823co_bbler
cockier154013623cocki_er
coddler113710833co_ddler
codriver1435913codriver
cognizer2055863cognizer
coiled95123943co__iled
coilers93619903co__ilers
coiner84323783co__iner
collider113410423collider
collier93618153colli_er
comaker153410603com_aker
combater1439383combater
comber125118503com__ber
combine133014723combine_
combined15269183combined
combiners15247943combiners
combines142814623combines
comember1644163comember
comer95832693com___er
comether1537253comether
commie124215523commi_e_
commies133718453commi_es
commixed2264743commixed
commixes2177353commixes
commoner142710633commoner
communer14349303communer
commuter143010153commuter
compacter17257883compacter
compadre15295883compadre
compare135814993compare_
compared153811823compared
comparers15319393comparers
compares143816433compares
comped135919873comp__ed
compeers143410013comp_eers
compel124412893comp__el
compelled1646133compelled
compellers1645193compellers
compels133210883compel_s
compere134616623comp__ere
compered153414923compered
comperes143217973comperes
compete134716553compete_
competed154113593competed
competes144117243competes
compiling1637763compiling
comping143518593compi_ng
complainer1645693complainer
compleat14710153comp_leat
complect1659013comp_lect
complete143412053comp_lete
completer153310413completer
complexer22316213complexer
complice1639333complice
complices1739253complices
complin13312073comp_lin
compline14313553compline
complines15312833complines
complins14313113complins
complot13310683comp_lot
comply152810383comp_l_y
compone136517193compone_
compose135716663compose_
composed154612063composed
composers153910623composers
composes145017113composes
composter15369563composter
compote135616463compote_
compotes144716513compotes
comprise14310813comprise_
comprised1648053comprised
comprises15510943comprises
comprize2368733comprize_
comprized2567223comprized
comprizes2468943comprizes
compted143813523comp_ted
compute134513663compute_
computed154110953computed
computers15339753computers
computes143914553computes
conciser12310243conciser
condoler113412123condoler
confider1438123confider
confiner13311193confiner
conifer123212643co_nifer
conniver1337493conniver
consider11310393consider
consoler102812613consoler
conspirer1355293conspirer
cooler84824713co__oler
cooper104221123coop__er
coper95336093co_p__er
copied114618563co_pi_ed
copiers114215963co_pi_ers
copies104130303co_pi_es
copilot11811263co_pilot
copper124321893co_p_per
coppice1537483coppice_
coppiced1734823coppiced
coppices1638243coppices
copter109822013co_p_ter
copular113810603co_pular
corkier133114303corki_er
cornier93017093corni_er
coruler9311713co_ruler
cosier84423753co_si_er
costlier1038523costlier
cottier93814173cotti_er
couple104415963coup_le_
coupled124312673coup_led
couplers123311323coup_lers
couples115317053coup_les
couplet114717943coup_let
courier93617893couri_er
cowier113616163co_wi_er
cowpie133511513cowpi_e_
cowpies143314283cowpi_es
cowriter13238883cowriter
cozier173315143co_zi_er
crampier14288903crampi_er
crepier1139733crepi_er
crimpier14287323crimpi_er
crippler14826713crippler
croupier1246883croupi_er
crumplier1543783crumplier
cupeler1177483c_upeler
cuppier1368323cuppi_er
cymbaler1743113cymbaler
dimplier1336673dimplier
dopier93515923do_pi_er
dumpier12409653dumpi_er
empaler11288353_empaler
gimpier12247943gimpi_er
goopier103910573goopi_er
gospeler1173963gospeler
hempier14319003hempi_er
homelier1338983homelier
homier116416993hom_i_er
hoppier143110703hoppi_er
humpier143110723humpi_er
impaler11298393_impaler
jumpier18317943jumpi_er
loopier93711193loopi_er
loppier11369723loppi_er
lumpier113410143lumpi_er
mailer84724183__mailer
miler75733063__m_iler
moiler84017263__moiler
mopier103914783mo_pi_er
oiler54628283_o__iler
pimplier1445413pimplier
recompile1545223recompile_
recompiled1744173recompiled
recompiles1645063recompiles
romper104213683romp__er
ropier84118803ro_pi_er
roupier9319493roupi_er
rumplier1235303rumplier
sampler113212013samp_ler
simpler112910863simp_ler
smiler83916683_sm_iler
soapier93411713soapi_er
soppier112711583soppi_er
soupier93111753soupi_er
toiler63918283to__iler
vampier14308233vampi_er
vomiter1237953vom_iter
wimpier14248053wimpi_er
wombier1436543wombi_er

Search took 7 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 Limit1461622066.39022873.6
3Display Results2062060.0802575.0
 (SQL Overall)1786912066.89325923.5
 
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.