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

152 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
ocelots97723(None) 
ocelot8813381ocelot_
celoms10412122_celoms
celts75325782_cel_ts
clots75627642_c_lots
coeloms1139062coeloms
coplots11511592coplots
helots95217702_helots
ocellus935982ocellus
oceloid1037972oceloid
omelets938332omelets
acerous9513343acerous
acetous9410363acetous
acoelous1047023acoelous
allots64019173_allots
ballots94116033ballots
beclogs1237073beclogs
belons84119413_belons
belows114614183_belows
belts75931163_bel_ts
besots86415453_besots
bibelots1295133bibelots
blots75626173__blots
brulots946223brulots
calos74431903_calo_s
celebs1037883_celebs
cellos84517803_cellos
cells75428063_cel_ls
celom9515693_celo_m
celotex1635023_celotex
cels65534973_cel__s
celt65646713_cel_t_
cenote83715843_cenote
cenotes92814543_cenotes
centos85920463_centos
cents74730333_ce_nts
ceros74726073_cero_s
cerous85821203_cerous
cestos84718093_cestos
cleats84919313_cleats
clefts114610163_clefts
clods85320863_c_lods
clogs85519553_c_logs
clons75228133_c_lons
cloots85113693_cloots
clops95924853_c_lops
clot66542423_c_lot_
cloth105817543_c_loth
cloths115512483_c_loths
clouts87017203_c_louts
cloys104916943_c_loys
cocklofts2043473cocklofts
coedits10310243coedits
coelom10310433coelo_m
coelome1139693coelome
coelomes1239293coelomes
coempts1335683coempts
collets93517903collets
collops112611753collops
cologs96517353_cologs
colons86028683_colons
colors86622373_colors
colts76633293_col_ts
complots1438163complots
coots75636843_c_oots
copilots1255753copilots
coplot10518273coplot_
cots68054843_c__ots
culets85518513_culets
cults75022553_cul_ts
delfts10439673_delfts
delts65731793_del_ts
depots94716343_depots
diglots9299503diglots
docents102810803doce_nts
dovecots1444323dovecots
drylots1143743drylots
echelons1385543echelons
eclats8313033ec_lats
eyelets1057523eyelets
feedlots12144453feedlots
felons93615763_felons
felts85324543_fel_ts
gelts65924613_gel_ts
gemots93712153_gemots
giglots9367863giglots
harlots103413293harlots
helos84928063_helo_s
helot85332683_helot_
iceboats1244973iceboats
iceless9219963iceless
kelts95222633_kel_ts
lots47652093___lots
matelots1047543matelots
melons84117713_melons
melts74930103_mel_ts
merlots92710123merlots
obelias9279043obelias
obelus8348403obel_us
obentos936713obentos
occults1135123occults
oceans81211003oce_ans
ocellar936533ocellar
ocellate1037873ocellate
ocelli836843ocel_li
ocherous1347013ocherous
ochrous1237943ochrous
ocicats11137413ocicats
octants9128733octants
octets839403oc_tets
octrois938343octrois
oculars948363oculars
oculist9310883oculist
oculists1037133oculists
oculus8178393ocul_us
odeons739023ode_ons
oleos55419683ole_o_s
omelet8317073omelet_
onerous7312973onerous
oots46446443o___ots
operons91411743operons
orlons6411013o_rlons
orlops847303o_rlops
outlets73616363outlets
outplots1086363outplots
overlets112312363overlets
overplots1436953overplots
ovolos9257203ovolo_s
owlets93110393o_wlets
pelota8612833_pelota
pelotas9410723_pelotas
pelts76128813_pel_ts
pilots84018873_pilots
plots75025673__plots
pomelos11218133pomelo_s
relets64025673_relets
replots93412633replots
repots85621003_repots
scents85317023sce_nts
scoots85315943sc_oots
scots74025913sc__ots
sculpts11377063sculpts
slots54830533__slots
smelts85412773smel_ts
spelts84614643spel_ts
sublots92410913sublots
telos55424523_telo_s
veldts10417753_veldts
welts85225193_wel_ts
woodlots1245343woodlots
zealots1636763zealots
zocalos1835393zocalo_s

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.406440125.6
2DLD Change Limit1340271526.19021652.2
3Display Results1521520.0463304.3
 (SQL Overall)1786911526.64226903.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.