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

169 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
ocelot881338(None) 
ocelots977231ocelots
celom9515692_celom
celt65646712_cel_t
clot66542422_c_lot
coelom10310432coelom
coplot10518272coplot
helot85332682_helot
ocelli836842ocelli
oceloid1037972oceloid
omelet8317072omelet
allot54933873_allot
ballot84624093ballot
beclog1136863beclog
begot84625953_begot
belon73924113_belon
below104617193_below
belt65754033_bel_t
besot76429713_besot
bibelot1167343bibelot
blot65842323__blot
brulot8912213brulot
calo64936443_calo_
calos74431903_calos
cel56040553_cel__
celeb9314873_celeb
cell65031723_cel_l
cella75420313_cella
celli76717693_celli
cello74919583_cello
cellos84517803_cellos
cells75428063_cells
celoms10412123_celoms
celotex1635023_celotex
cels65534973_cel_s
celts75325783_celts
cenote83715843_cenote
cent67451013_ce_nt
cento76625173_cento
cero66329453_cero_
ceros74726073_ceros
chalot113020133chalot
cleat76335063_cleat
cleft106222853_cleft
clept95725773_clept
clod76124613_c_lod
clog76123243_c_log
clon66232483_c_lon
cloot76127053_cloot
clop86929893_c_lop
cloth105817543_c_loth
clots75627643_c_lots
clout75330463_c_lout
cloy96623833_c_loy
cockloft1945693cockloft
coedit9316243coedit
coelome1139693coelome
coeloms1139063coeloms
coempt12311033coempt
collet84030363collet
collop107312313collop
colog86619933_colog
colon78630193_colon
color76123743_color
colt67158243_col_t
complot13310683complot
coot67860383_c_oot
copilot11811263copilot
coplots11511593coplots
cot510483223_c__ot
culet76040343_culet
cult66541153_cul_t
delft95623323_delft
delt57855273_del_t
depot85727923_depot
diglot83014333diglot
docent92918683doce_nt
dovecot1356733dovecot
drylot1037403drylot
dwelt94316523dwel_t
echelon1276163echelon
eclat7523603ec_lat
eyelet9514533eyelet
feedlot11135933feedlot
felon84619293_felon
felt75146933_fel_t
gelt56448013_gel_t
gemot84024233_gemot
giglot84013133giglot
hallot95426783hallot
harlot94422803harlot
helo75332853_helo_
helos84928063_helos
helots95217703_helots
iceboat1147163iceboat
icebox1753083icebox
kelt85343193_kel_t
knelt94617683knel_t
lot38179263___lot
matelot9411573matelot
melon73922083_melon
melt65752893_mel_t
merlot83217613merlot
nocent83217413noce_nt
obeli73711933obel_i
obelia8329453obelia
obelus8348403obelus
obento837893obento
occult1038433occult
ocean71212963oce_an
oceans81211003oceans
ocellar936533ocellar
ocellate1037873ocellate
ocellus935983ocellus
ocicat101412813ocicat
octant81216553octant
octet7324063oc_tet
octroi837363octroi
ocular8610133ocular
oculi72010793ocul_i
oculist9310883oculist
oculus8178393oculus
odeon6411483ode_on
oleo46630483ole_o_
oleos55419683ole_os
omelets938333omelets
oncet74626543once__t
oot311274693o___ot
operon8811773operon
orlon5415003o_rlon
orlop7410903o_rlop
outlet63728683outlet
outplot9109483outplot
overhot13411223overhot
overlet102619033overlet
overlit102714743overlit
overplot1338543overplot
overt85630723ove_rt
ovolo8339173ovolo_
ovolos9257203ovolos
owlet83324463o_wlet
pelon74423213_pelon
pelota8612833_pelota
pelt67651083_pel_t
pilot77435063_pilot
plot66141233__plot
pomelo10238663pomelo_
pomelos11218133pomelos
relet54749823_relet
relit55340683_relit
replot83818593replot
repot75132623_repot
scent75831623sce_nt
scoot75729153sc_oot
scot66242613sc__ot
sculpt104412693sculpt
slot46049833__slot
smelt74726783smel_t
spelt75430193spel_t
sublot82315523sublot
teloi54217383_teloi
telos55424523_telos
veldt94819863_veldt
welt75547863_wel_t
woodlot1147023woodlot
yclept1336013yclept
zealot15313473zealot
zocalo1735803zocalo_
zocalos1835393zocalos

Search took 9 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.423422437.4
2DLD Change Limit1127161697.65614722.6
3Display Results1691690.0463673.9
 (SQL Overall)1786911698.12521992.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.