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

292 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
coelom1031042(None) 
celom9515681c_elom
coelome1139681coelome
coeloms1139061coeloms
celoms10412122c_eloms
coelomes1239292coelomes
coelomic1445712coelomic
collop107312312collop
colog86619932co_log
colon78630192co_lon
color76123742co_lor
condom114215362condom
coplot10518272coplot
coulomb1344552coulomb
ocelot8813382ocelot
acoelous1047023acoelous
belon73924113_belon
below104617193_below
besom95716973_besom
bollox1548743bollox
bolo65535953bo_lo_
bolos75531373bo_los
boom87435673bo__om
boredom1236933boredom
bosom95516923bo_som
bottom1048713bottom
caecum1238183caecum
caeoma1039033cae_oma
callow114714663callow
calm85032363c_al_m
calo64936443c_alo_
calos74431903c_alos
carom95025563c_arom
carrom10513403carrom
cecum11611843c_ecum
cel56040553c_el__
celeb9314873c_eleb
cell65031723c_el_l
cella75420313c_ella
celli76717693c_elli
cello74919583c_ello
cellos84517803cellos
cells75428063c_ells
cels65534973c_el_s
celt65646713c_el_t
celts75325783c_elts
cero66329453c_ero_
ceros74726073c_eros
chalot113020133chalot
chefdom18134063chefdom
chegoe1237273chegoe
chela103916803chel_a
chelae113614603chelae
chelas113817203chelas
cheloid13310823cheloid
chemo12313633chemo_
chemos13311723chemos
cholo105217973cholo_
cholos114716853cholos
clam86332293c__lam
cleome1039083cle_ome
clod76124613c__lod
clog76123243c__log
clomb115714703c__lomb
clomp115615703c__lomp
clon66232483c__lon
clop86929893c__lop
clot66542423c__lot
cloy96623833c__loy
coal66939253coal__
coala77521123coal_a
coalas87418963coalas
coalbox1844103coalbox
coaled95022703coaled
coaler84121703coaler
coals76129603coal_s
coaly105521593coal_y
coble94823173cobl_e
cobles104622883cobles
coco87330603co_co_
cocoa98517883co_coa
cocoon10312263cocoon
cocos95624693co_cos
codlin94516433codlin
codon86522853co_don
coed77140543coe__d
coedit9316233coedit
coeds85920163coe_ds
coeliac1138233coeliac
coelomata1385313coelomata
coelomate1398083coelomate
coemploy1743323coemploy
coempt12311033coempt
coerce10310403coerce
coeval1138893coeval
cogon89120903co_gon
coho97524493co_ho_
cohog117813043co_hog
cohos105921853co_hos
coil66439653coil__
coiled95123933coiled
coiler84421593coiler
coils75030083coil_s
col59360353co_l__
cola66541393co_l_a
colas75436773co_las
colby124415063co_lby
cold77338773co_l_d
colds85726973co_lds
cole66956113co_l_e
colead94114643colead
coled85540753co_led
coles76055063co_les
coleus86818273coleus
colic95726173co_lic
colin76231693co_lin
collar83816173collar
collet84030363collet
collie83621993collie
colloid10312873colloid
collops112611753collops
colly104926773co_lly
colobi105011083co_lobi
cologs96517353co_logs
colone85425003co_lone
coloni85619203co_loni
colons86028683co_lons
colony115417273co_lony
colors86622373co_lors
colour85915083co_lour
cols66553083co_l_s
colt67158243co_l_t
colts76633293co_lts
column1038103co_lumn
coly96940533co_l_y
colza165112983co_lza
combo114519433combo_
combos125316613combos
comedo11359603comedo_
comedos12329073comedos
comely134213733comel_y
common12310803common
complot13310683complot
compo115318573compo_
compos124818803compos
condo85322593condo_
condoms124214083condoms
condor94616963condor
condos94322333condos
conform14310453conform
congo85623133congo_
congos94219883congos
congou94313243congou
conium10415313conium
consol82614113consol
conto76027173conto_
contos84923233contos
convoy14348543convoy
coo59566363co__o_
coocoo1069693coocoo
coof96643273co__of
cook107236933co__ok
cool66940493co__ol
cooled95224583cooled
cooler84824713cooler
coolie83821603coolie
coolly114811393coolly
cools75632633cool_s
coolth1139513coolth
cooly105525423cool_y
coomb115615703co__omb
coon67248943co__on
coop87238653co__op
coos67456493co__os
coot67860383co__ot
copalm125010813copalm
copepod1444853copepod
copilot11811263copilot
coplots11511593coplots
cordon95017293cordon
corium10315723corium
corm85735373co__rm
cosmos10311753cosmos
cotton8312993cotton
could86517713coul_d
coulee8323503coulee
coulis84018753coulis
couloir936143couloir
coulombs1443093coulombs
coupon102810993coupon
cowboy1637063cowboy
cowflop1742893cowflop
cowl97530813cowl__
cowled125218383cowled
cowls106922213cowl_s
cowplop1643363cowplop
cowpox2035003cowpox
coxcomb2243293coxcomb
coydog1335133coydog
coyly135614893coyl_y
coypou13268403coypou
cream95721343cre_am
credo84815563credo_
credos94612843credos
creole8913723creole
crepon1039933crepon
cresol8310203cresol
culm85822383c_ul_m
custom104010273custom
cyclo1237703cyclo_
cyclos1338073cyclos
doblon938013doblon
dogdom1186363dogdom
dogedom1244663dogedom
dollop9259363dollop
dolor67617963do_lor
doom76430073do__om
echelon1276163echelon
elm57531743__el_m
felon84619293_felon
foetor939563foetor
follow124010353follow
genom83716843_genom
glom75424383__glom
golem8416113go_lem
helm95530023_hel_m
helo75332853_helo_
helos84928063_helos
helot85332683_helot
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
holm95628103ho_l_m
hoteldom1463383hoteldom
kelim11912543_kelim
koel84519943koel__
koels94613903koel_s
kolo87026223ko_lo_
kolos94921213ko_los
lollop8238783lollop
loom67035053lo__om
melon73922083_melon
mohelim1444763mohelim
myeloma1444033myeloma
noel45226553noel__
noels56418703noel_s
nolo46229313no_lo_
nolos54423353no_los
noncom1039683noncom
ocelli836843ocelli
oceloid1037963oceloid
ocelots977233ocelots
oleo46630483_oleo_
oleos55419683_oleos
oleum73613323_oleum
orlon5415003_orlon
orlop7410903_orlop
pelon74423213_pelon
phenom1339473phenom
poem86225773poe__m
pogrom1138593pogrom
polo66236633po_lo_
polos76129913po_los
pomelo10238663pomelo_
pomelos11218133pomelos
pompom1436493pompom
popedom1445453popedom
prelim10311423prelim
room66235083ro__om
scollop11275433scollop
seldom939403_seldom
shalom11810913shalom
sholom11910093sholom
skelm114211283skel_m
slalom888173slalom
sodom8814903so_dom
solo45538943so_lo_
solon55026133so_lon
solos54830793so_los
solum74717603so_lum
teloi54217383_teloi
telome8311923_telome
telos55424523_telos
toom66532933to__om
velum10713383_velum
venom103914863_venom
whelm134611983whel_m
whilom1436133whilom
woesome1246733woesome
zoom156722103zo__om

Search took 6 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162925.48320557.4
3Display Results2922920.0803650.0
 (SQL Overall)1786912925.71931245.1
 
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.