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

302 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
compile1331244(None) 
compiled1537811compiled
compiler1438371compiler
compiles14311981compiles
campily1638272campily
combine133014722combine
commie124215522commi_e
compare135814992compare
compel124412892compel_
compels133210882compels
compere134616622compere
compete134716552compete
compilers1537052compilers
comping143518592comping
complex2037242comp_lex
complice1639332complice
complied1539672complied
complier14310252complier
complies14314522complies
complin13312072complin
compline14313552compline
comply152810382comp_ly
compone136517192compone
compose135716662compose
compote135616462compote
comprise14310812comprise
comprize2368732comprize
compute134513662compute
coppice1537482coppice
couple104415962coup_le
cowpie133511512cowpi_e
recompile1545222recompile
ample94720303_amp_le
ampule10710613_ampule
bumpily1665653bumpily
camail10314833camail_
camailed1336553camailed
camails11311753camails
camise103319633cam_ise
cammie124615293cammi_e
camomile14156323camomile
campanile1544403campanile
campfire1744023campfire
camphine1738373camphine
camphire1745893camphire
campi116217783campi__
campier133313273campier
camping143118973camping
campion133011413campion
campsite1447413campsite
carpale113414353carpale
centile94217183centile
chile105626893c__hile
chomping18339883chomping
chopine143512263chopine
choppily2044133choppily
clodpole1343603clodpole
clomping15329653clomping
cobble123615263co_bble
coble94823173co__ble
cocaine111315173cocaine
cockily1838493cockily
cockle143913573co_ckle
codable12311663codable
coddle104713853co_ddle
codeine103815033codeine
codpiece1544063codpiece
codrive1337653codrive
coesite9713623coesite
coffle14359043co_ffle
cognise1059683cognise
cognize1957683cognize
coil66439653co__il_
coiled95123933co__iled
coiler84421593co__iler
coils75030083co__ils
cole66956113co___le
collide103214783collide
collie83621993colli_e
comade114415323com_ade
comae97128423com__ae
comake144413423com_ake
comal95125133com_al_
comate104124843com_ate
combe116223543com__be
combined15269183combined
combiner14259723combiner
combines142814623combines
combing143714733combing
comblike1846293comblike
come87547703com___e
comelier12310653comelier
comelily1546693comelily
comely134213733com_ely
comfier1439163comfier
comfit133112423comfi_t
comfits14328743comfits
comic114721813com_i_c
comics124015563com_ics
coming114225453com_ing
comingle1336053comingle
comity13312713com_ity
comix163513203com_i_x
commies133718453commies
commingle1645063commingle
commit124016703commi_t
commits133812383commits
commix19407763commi_x
commixed2264743commixed
commixes2177353commixes
commixt20357623commixt
commode1438123commode
commove1635963commove
commune13329363commune
commute134310443commute
comose105016843com_ose
comp106731253comp___
compact153712213compact
compadre15295883compadre
company1619711143company
compared153811823compared
comparer143611363comparer
compares143816433compares
compart134016003compart
compas125817063comp_as
compass13379563compass
compatible18125573compatible
comped135919873comp_ed
compeer133811553compeer
compelled1646133compelled
compeller1546293compeller
compend144010303compend
compered153414923compered
comperes143217973comperes
competed154113593competed
competes144117243competes
compiling1637763compiling
compleat14710153comp_leat
complect1659013comp_lect
complete143412053complete
complices1739253complices
compliers1538293compliers
complines15312833complines
complins14313103complins
complot13310683complot
compo115318573comp__o
compony1613011913compony
comport133616843comport
compos124818803comp_os
composed154612063composed
composer145012953composer
composes145017113composes
composite15410153composite
compost134515353compost
compotes144716513compotes
comprised1648053comprised
comprises15510943comprises
comprized2567223comprized
comprizes2468943comprizes
comps115526053comp__s
compt116328223comp__t
compted143813523compted
compting153013603compting
compts125216653comp_ts
computed154110953computed
computer144511513computer
computes143914553computes
comrade12139213comrade
comte96125473com__te
concise11314473concise
condole102914953condole
condyle13247053condyle
confide13310203confide
confine12315583confine
coniine9316803coniine
conine84528553co_nine
connive1238993connive
console92715983console
conspire1257873conspire
cookie123716043cooki_e
coolie83821603cooli_e
cooping123918933cooping
cootie84223093cooti_e
copal95621783co_pal_
copalm125010813co_palm
copals105018943co_pals
cope86847383co_p__e
copied114618563co_pied
copier103722893co_pier
copies104130303co_pies
copihue1444143co_pihue
copilot11811263co_pilot
coping113927663co_ping
coppiced1734823coppiced
coppices1638243coppices
copping143918593copping
copse95623923co_p_se
copula102812043co_pula
copulae112810613co_pulae
coquille1944033coquille
coracle112011723coracle
corbie103618203corbi_e
cordite10315263cordite
cormlike1646703cormlike
cornice11612933cornice
cornicle1258783cornicle
cornily12410853cornily
corpse104013403corp_se
corrie83621223corri_e
corvine122113643corvine
cosie74728263co_si_e
cosily113613853co_sily
cosine83823513co_sine
costive12312843costive
coupe96023483coup__e
couping124317023couping
coupled124312673coup_led
coupler114713013coup_ler
couples115317053coup_les
couplet114717943coup_let
cowhide1636133cowhide
cowpies143314283cowpies
cowpoke1835103cowpoke
cowrie113814283cowri_e
cowrite123612683cowrite
cozie163519133co_zi_e
cozily20349703co_zily
crimple13408693crimp_le
cripple13378583cripple
croppie13278793croppi_e
croupily1544743croupily
crumple13368363crump_le
cupule103410723c_upule
dimple113512793dimp_le
docile94213123do_cile
domaine10610503domaine
domicile1346083domicile
domine92918253dom_ine
dopily123510463do_pily
dumpily1566233dumpily
empale102611263_empale
empire1039323_empire
eolipile1045093eolipile
eolopile1045863eolopile
fomite113314073fom_ite
hempie132410563hempi_e
homie104622533hom_i_e
homily144712333hom_ily
homophile1948103homophile
hopple132910483ho_pple
hospice14117063hospice
hostile10312553hostile
impale102811663_impale
jumpily2174983jumpily
koppie14277883koppi_e
loopily1236803loopily
lumpily1476563lumpily
maile75232223__maile
mile66352573__m_ile
mobile103613543mo_bile
motile83818343mo_tile
opine77422463_o_pine
orpine83914483_orpine
pile65649693___pile
pimple123512963pimp_le
pommie123710503pommi_e
popple92710983po_pple
potpie103412433potpi_e
rampike1536603rampike
rampole1139693rampole
recompiled1744173recompiled
recompiles1645063recompiles
rimple103814583rimp_le
romaine9512123romaine
romping123113033romping
rompish1436693rompish
ropily113312443ro_pily
roupily1246653roupily
rumple103913013rump_le
sample104215013samp_le
semple103212753semp_le
simile83115633sim_ile
simple104315173simp_le
smile74823923_sm_ile
soapily1237963soapily
somite84519373som_ite
sopite84917713so_pite
spile75230083__spile
temple102811333temp_le
toile54626493to__ile
tompion11247103tompion
topple104411323to_pple
tortile7313193tortile
umpire1047893_umpire
unpile81914323_unpile
uppile10178503_uppile
vampire14296673vampire
voile84719723vo__ile
wimple133611363wimp_le
woodpile1444093woodpile
zombie1937323zombi_e
zoophile2246453zoophile

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340273026.43620824.6
3Display Results3023020.1102745.5
 (SQL Overall)1786913026.68626726.1
 
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.