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

395 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
ceilings1139799(None) 
ceiling103416721ceiling_
veilings12357311veilings
bellings113811152bellings
callings113613832callings
carlings114015862carlings
catlings113712042catlings
ceilidhs1442132ceilidhs
ceilinged1342372ceilinged
ceilis85413742ceili__s
celling103921262celling_
chitlings15255902chitlings
clings95716212c__lings
codlings123110102codlings
coiling103723452coiling_
cowlings14359782cowlings
curlings114110382curlings
cyclings1635372cyclings
cymlings1634212cymlings
dealings103510702dealings
failings123811012failings
feelings12338932feelings
filings115213072_filings
heelings12359752heelings
heiling113616362heiling_
keglings14245232keglings
mailings113011922mailings
peelings11339522peelings
pilings103313612_pilings
railings93412162railings
reelings94012562reelings
sailings93513252sailings
seisings9398522seisings
seizings18326472seizings
spilings11308812spilings
tailings93211672tailings
tilings84212792_tilings
veiling113615292veiling_
veinings12306432veinings
yealings12257702yealings
ablings1038743_ablings
ailing74331013_ailing_
airings83913843_airings
anglings10228273anglings
anilines8415143anilines
anilingus1043113anilingus
anilins7416793anilin_s
bailing103723523bailing_
beadings123711783beadings
bearings113912253bearings
beatings114113233beatings
beddings13407923beddings
beelines103312803beelines
beings94613033be__ings
belling103825073belling_
belongs10408223be_longs
beltings11369253beltings
berlines102315453berlines
berlins93216013berlin_s
billings113412633billings
birlings11359613birlings
boiling103819673boiling_
bowlings14408753bowlings
brislings12236363brislings
buildings1334253buildings
cabling124017553cabling_
cagelings1335413cagelings
calkings15289223calkings
calling103826773calling_
campings154010203campings
cannings113710333cannings
caplins113515993caplin_s
cappings15369493cappings
cardings123812643cardings
carlines103521673carlines
carling103727063carling_
carlins93921923carlin_s
carpings133812393carpings
carvings143810213carvings
casings104013513c_asings
castings113614053castings
catling104819793catling_
catlins93818843catlin_s
caulkings1633353caulkings
caviling14310113caviling_
cavings134712543c_avings
ceasing104118263ceasing_
ceding104014803ce_ding_
ceilers93912533ceil_ers
ceili75814793ceili___
ceilidh1345363ceili_dh
ceils75019403ceil___s
celiacs11157893ce_liacs
cellists1038563cellists
censing104215263censing_
centrings12227603centrings
cering94522533ce_ring_
cessing103814813cessing_
chasings14318253chasings
chiding143911593chiding_
childing15288503childing_
chiliads1445853chiliads
chilidogs16122773chilidogs
chilies124218303chili_es
chilis115517873chili__s
chilling143512183chilling_
chiming153311833chiming_
chining133316843chining_
chitins122713793chitin_s
chitling142910663chitling_
chitlins13289393chitlin_s
cholines132214493cholines
cilices113814023c_ilices
citing94220183c_iting_
clangs95113613c__langs
clearings12286063clearings
clines84926043c__lines
cling86424673c__ling_
clingy12659063c__lingy
clinks125815063c__links
clippings16273753clippings
clonings11307433clonings
closings11277673closings
coaling103722823coaling_
coamings13349293coamings
coatings113811843coatings
codling114418953codling_
codlins104116243codlin_s
coifing133213893coifing_
coining103920553coining_
colins85229043c_olin_s
collins93419833collin_s
combings15348323combings
comings124013533c_omings
cookings15358603cookings
cooling103422573cooling_
copings124111843c_opings
cordings123011363cordings
couplings1435543couplings
covings134511243c_ovings
cowling134017423cowling_
cravings14428223cravings
creeling113513363creeling_
crestings12298043crestings
cribbings16273173cribbings
criminis12257303criminis
cruisings12214113cruisings
cuisines1049373cuisines
culling103921303culling_
cunnings11357343cunnings
cuppings15336053cuppings
curbings13407313curbings
curling104320183curling_
cutlines102413273cutlines
cuttings11277613cuttings
cycling1537213cycling_
cyclins1438303cyclin_s
cymblings1942663cymblings
cymling1536273cymling_
cymlins1436693cymlin_s
darlings103710383darlings
dealing94323233dealing_
deckings16346683deckings
declines113315803declines
defiling132812463defiling_
deicing11312193deicing_
detailings12243923detailings
deviling1311812853deviling_
dialings10329823dialings
drillings11285823drillings
drivings13265763drivings
dwellings14244213dwellings
eanlings9128473eanlings
earings84517713_earings
eatings84616443_eatings
edgings10256243_edgings
elints65816423_e_lints
endings92910443_endings
erlkings1333563_erlkings
exiling15311083exiling_
failing113521333failing_
fairings12388193fairings
fatlings12359303fatlings
feeling113617073feeling_
felines104718073fe_lines
felling113321133felling_
feltings12317903feltings
fencings14225663fencings
fettlings1353753fettlings
filing103823763_filing_
fillings122910503fillings
finings114311773_finings
firings114112333_firings
fixings18347443_fixings
flings106715283__flings
foiling113317653foiling_
foulings12327943foulings
fowlings15377243fowlings
frillings13265803frillings
gearings10359503gearings
geldings11316163geldings
gelling93219763gelling_
gildings11356973_gildings
godlings11367493godlings
goslings10297553goslings
guiling93214213guiling_
hailing113820693hailing_
headings133510493headings
healing113922963healing_
hearings123611853hearings
heeling113618513heeling_
heiring113312903heiring_
helling114623223helling_
helpings14255653helpings
hemlines13310623hemlines
herrings12379533herrings
hidings12349703_hidings
hildings13347503_hildings
hurlings12388213hurlings
iceblinks1741513iceblinks
icings9428453__icings
inklings13246383inklings
jailing153415843jailing_
jelling153516613jelling_
jestings16368023jestings
joinings16285243joinings
keeling123515123keeling_
keepings15345943keepings
kegling13309363kegling_
kennings13315273kennings
killings133710483killings
kiltings13327083_kiltings
kitlings13318103kitlings
leadings103511243leadings
leanings94010183leanings
leasings9379843leasings
leavings12407493leavings
leggings11316193leggings
lemmings13254733lemmings
likings12539413_likings
lings67135773___lings
linings84313073_linings
livings11408923_livings
mailing102923343mailing_
mallings113413093mallings
marlings113713503marlings
meanings11329163meanings
meetings11287413meetings
melling102822633melling_
mendings12338303mendings
merlins93015813merlin_s
mewling13329513mewling_
millings113712583millings
minings103912073_minings
moiling103417663moiling_
nailing83419963nailing_
neckings15346113neckings
needlings11294693needlings
nervings12256323nervings
nestlings1074313nestlings
nettings9288103nettings
oiling74925313_oiling_
pairings11398313pairings
palings103915823_palings
pealing104123203pealing_
peeling102919873peeling_
peining104619153peining_
peising103416763peising_
pencilings1543153pencilings
periling11316863periling_
pettings11349703pettings
piecings1345343piecings
piling95025593_piling_
pipings12338253_pipings
primings13338143primings
pulings103511323_pulings
purlings113910283purlings
quillings19225743quillings
quiltings19214683quiltings
quislings19184713quislings
railing83325643railing_
raisings9338443raisings
readings103512643readings
realigns936253realigns
reclines103718543reclines
redlines93916083redlines
redwings13305733redwings
reedings103510363reedings
reedlings11236343reedlings
reeling83126863reeling_
refiling123116533refiling_
reining84425323reining_
reiving113316843reiving_
relines75331323re_lines
relinks114510223re_links
reoiling93217213reoiling_
resiling93520173resiling_
resilins83013373resilin_s
retailings11265233retailings
retiling93319483retiling_
reviling122917213reviling_
ridings93412093_ridings
rieslings1034493rieslings
riflings12227313riflings
riling74227973_riling_
risings83211893_risings
roiling83220453roiling_
rollings9419953rollings
rulings83310383_rulings
sailing83927373sailing_
saplings11269803saplings
schillings16243273schillings
sealing83528563sealing_
seatings93614303seatings
seedlings11195953seedlings
seeings84411293se_eings
seeling83522003seeling_
seemings11337643seemings
seining84020773seining_
seising84018863seising_
seisins73614393seisin_s
seizing174114833seizing_
seizins164010133seizin_s
selling83225833selling_
sergings10299213sergings
servings12249223servings
setlines8312743setlines
settings93810073settings
settlings1054683settlings
sewings11369173se_wings
shealings13317563shealings
shielings13237123shielings
shilingi1233843shilingi
shillings13348093shillings
siblings11108123siblings
sidings94011463_sidings
sizings17378013_sizings
skiings12295733ski_ings
skillings14246133skillings
slings74618013__slings
smiling103915443smiling_
soiling83422323soiling_
speiling113612973speiling_
spellings12296553spellings
spiling102919703spiling_
stealings10318853stealings
sterlings10308753sterlings
stylings12276233stylings
subceilings1652573subceilings
suitings9288953suitings
swellings13296103swellings
tailing82923103tailing_
telling83321093telling_
tidings93810263_tidings
tiling73426553_tiling_
timings10279303_timings
toiling83219023toiling_
toolings9248473toolings
triflings13235983triflings
twillings13234913twillings
unslings937283unslings
unveilings1443103unveilings
upflings1433733upflings
vailing113817953vailing_
vealing114217423vealing_
veining114713893veining_
vestings12359143vestings
viewings1533983viewings
vikings15386623_vikings
voicings14274613voicings
wailing113620903wailing_
waitings123413743waitings
weaklings1794003weaklings
weanlings1394413weanlings
webbings1633243webbings
weddings14355533weddings
weepings14346483weepings
welling112920313welling_
weltings12388203weltings
westings12429803westings
wettings12348403wettings
whalings15256763whalings
wheelings16284943wheelings
whiling143511743whiling_
whitings15287063whitings
wildings13287933_wildings
wiling103024293_wiling_
wirings113910113_wirings
witlings12328443witlings
writings12298113writings
yealing112716383yealing_
yeanlings1393693yeanlings
yearlings1384203yearlings
yeelins1038813yeelin_s
yelling113516703yelling_

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 Filter1786911461620.453394461.4
2DLD Change Limit1461623957.61019206.6
3Display Results3953950.1562532.1
 (SQL Overall)1786913958.21921741.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.