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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
dilatable124685(None) 
dilatably1544411dilatably
datable101714232d__atable
debatable1446312debatable
delayable1546062delayable
deletable12149502deletable
dilatate947772dilata_te
palatable1346382palatable
relatable11310052relatable
tiltable10159012til_table
abatable1238023_abatable
beatable121612243_beatable
billable12179503bil_lable
bitable11312203bi__table
blamable1436693_blamable
boatable121610263_boatable
cheatable1646713cheatable
chelatable1743613chelatable
citable11313463ci__table
creatable1339563creatable
dateable1149443d__ateable
debatably1754213debatably
decayable1745623decayable
declarable1544983declarable
delectable15247383delectable
delegable13136643delegable
denotable1238373denotable
depletable1544973depletable
deputable1487043deputable
dialyzable2542433dialyzable
dilatancy1552523dilatancy
dilatant948203dilata_nt
dilatants1044513dilatants
dilatator1044143dilatator
dilate73220693dilat___e
dilative1239523dilat_ive
dimmable1536113di_mmable
dippable1536123di_ppable
disable10516433di__sable
disenable1249673disenable
dislikable1744323dislikable
displayable1953133displayable
disputable1545063disputable
dividable1645003dividable
doubtable1445163doubtable
draftable1575563draftable
drapable1377573d_rapable
drawable1467113d_rawable
drillable1245133dril_lable
dubitable1445093dubitable
eatable91717603__eatable
editable11310423edi__table
equatable2045193equatable
fightable1844373fightable
fileable13179223fil_eable
fillable13179573fil_lable
filmable15157133fil_mable
filtrable1484263filtrable
fittable1337093fi_ttable
floatable1444983floatable
getatable1235953getatable
giftable1465893gi_ftable
hatable121713963__hatable
heatable131612043_heatable
hittable1336853hi_ttable
imitable1239123_imitable
inarable10313133_inarable
inflatable1546003inflatable
instable10313203_instable
isolatable1244373isolatable
killable14168133kil_lable
liftable1376863li_ftable
limitable1345643limitable
listable10810313li_stable
locatable1345573locatable
meltable12310473mel_table
millable121710133mil_lable
palatably1644443palatably
pivotable1644563pivotable
placable14169243_placable
plantable1337273_plantable
playable15137923_playable
ratable91717553__ratable
relaxable1836363relaxable
rotatable1146653rotatable
slakable14177553_slakable
slayable13157563_slayable
statable10310703_statable
tillable10159753til_lable
timetable1346873timetable
titratable1243693titratable
treatable1139323treatable
undatable1238983undatable
uneatable11311693uneatable
vacatable1644643vacatable
visitable1445873visitable
willable13168683wil_lable

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit148641976.81321817.3
3Display Results97970.0462108.7
 (SQL Overall)178691977.27924548.8
 
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.