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 “ceils” with Change Limit: [1] [2]

(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
ceils7501940(None) 
ceil65725061ceil_
ceili75814791ceili
ceilis85413741ceilis
cells75428061cells
cels65534971ce_ls
coils75030081coils
deils65722861deils
heils85222191heils
veils84918801veils
ails45654722_ails
anils56326722anils
arils58732202arils
axils127217502axils
bails75933522bails
bells76432162bells
bels66142492be_ls
bezils1711310602bezils
boils75427192boils
caids85226432caids
cains75334302cains
calls75634732calls
carls77037422carls
cauls75727772cauls
cavils114014392cavils
cebids11439182cebids
cedes84927332cedes
cedis84317082cedis
cees65941592ce_es
ceiba938702ceiba
ceibas1038502ceibas
ceiled94114952ceiled
ceiler84013962ceiler
ceilers93912532ceilers
cel56040552ce_l_
cell65031722ce_ll
cella75420312cella
celli76717692celli
cello74919582cello
cellos84517802cellos
celt65646712ce_lt
celts75325782celts
cents74730332cents
ceorls848162ceorls
cepes94424462cepes
ceps86125952ce_ps
ceres75540012ceres
cerias83321982cerias
ceros74726072ceros
cess65326052ce_ss
cetes75731102cetes
chias104625522chias
chics123920942chics
chiels115115932chiels
child114516222child
chile105626892chile
chiles115425302chiles
chili106218482chili
chilis115517872chilis
chill105619872chill
chills114717702chills
chins105631462chins
chips125721252chips
chis95933312chi_s
chits105424572chits
cigs75625112c_igs
cis57748042c_i_s
clips96018302clips
coals76129602coals
coifs105718702coifs
coil66439652coil_
coins75834552coins
coirs75221052coirs
cols66553082c_ols
cools75632632cools
cowls106922212cowls
creels84416942creels
cribs94516752cribs
cries75438402cries
cris66233432cri_s
crits75527572crits
cuifs104814692cuifs
culls75425812culls
curls74927102curls
deals65435342deals
deil56231622deil_
delis64928542delis
dells66630942dells
dels56745472de_ls
devils104412812devils
eels46536742_eels
ells46431352_ells
els37645722_e_ls
evils84114262evils
fails85631482fails
feels85223042feels
fells85327382fells
fils75838702_fils
foils85025812foils
gels56836102ge_ls
hails85231642hails
heals85733462heals
heels85625532heels
heil76328932heil_
heirs85618562heirs
hells85032042hells
herls85226432herls
jails125422942jails
jells125522162jells
kails95525222kails
keels94622412keels
keirs95313682keirs
kevils13358332kevils
leis45739602lei_s
mails76037782mails
meals75933382meals
mells75031332mells
mels65941532me_ls
merls77423902merls
mewls105813232mewls
mils66045342_mils
moils76125752moils
nails55730402nails
neifs85613042neifs
nils46132462_nils
noils55024332noils
oils46337982_oils
pails75833062pails
peals75235492peals
peels75226422peels
peins76128062peins
perils84121852perils
rails55937402rails
reals55038652reals
reels55333262reels
reifs84819092reifs
reins56234562reins
reis45343232rei_s
reoils64516872reoils
riels55121332riels
roils54826792roils
sails55738102sails
seals54839702seals
seels55632822seels
seifs85019332seifs
seis45542392sei_s
sells55134432sells
sels46345982se_ls
soils55327982soils
speils84116222speils
tails55634192tails
teals56234132teals
teels55726372teels
tells55828942tells
tels46841692te_ls
tils45739622_tils
toils54527492toils
vails85825932vails
veals84926192veals
veil75523592veil_
veins84620492veins
vexils1647172vexils
wails86631482wails
weals85428742weals
weirs84316492weirs
wells85426192wells
yells85821942yells
zeals145320852zeals
zeins144715392zeins

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001691.50035866.7
3Display Results1691690.0463673.9
 (SQL Overall)1786911691.87295454.6
 
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.