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

183 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
citeable123841(None) 
biteable1237931biteable
citable11313461cit_able
bitable11312202bit_able
cuttable1247952cuttable
dateable1149442dateable
fileable13179222fileable
fineable131810332fineable
fireable131710222fireable
fittable1337092fittable
giveable14155752giveable
hateable1339372hateable
hireable13139082hireable
hittable1336852hittable
likeable14166472likeable
lineable101811082lineable
liveable13177662liveable
mineable121611052mineable
pitiable1238292pitiable
rateable10311442rateable
rideable1158652rideable
sizeable1937112sizeable
tithable1336852tithable
titrable1038962titrable
toteable1048352toteable
vitiable1337502vitiable
voteable1347212voteable
writeable1444612writeable
actable11313473act_able
agitable1138583agit_able
alterable1149163alterable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
cable95329913c___able
callable12310753callable
canoeable1347103canoeable
capable13313363c_apable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
catchable1845713catchable
causable1239973causable
chaseable1646343chaseable
chewable1835443chewable
chippable2073353chippable
chokeable2053853chokeable
cicale10314503ci_ca_le
cineaste1045743cineaste
cineole91010003cine_ole
citadel1044383cit_adel
citole8311503cit__ole
citral81113893citra_l_
citrals91111673citra_ls
citrate92216803citra_te
clickable1944303clickable
climbable1743603climbable
clippable1773463clippable
closable12168003closable
closeable13155023closeable
clubable1436093clubable
codable12311663c_odable
cogitable1446943cogit_able
coinable12311583coinable
cookable16147973cookable
copyable1736623copyable
coverable1649103coverable
covetable1648163covetable
culpable1436283culpable
curable112414513c_urable
curbable1447663curbable
datable101714233dat_able
dimmable1536113dimmable
dippable1536123dippable
disable10516433di_sable
disenable1249673disenable
driveable1544523driveable
dutiable1137373dutiable
dyeable1337303_dyeable
eatable91717603eat_able
editable11310423edit_able
enterable11312643enterable
evitable1339323evit_able
excitable2056243excit_able
eyeable1239063_eyeable
faceable15108493faceable
fillable13179573fillable
filmable15157133filmable
filterable1543723filterable
filtrable1484263filtrable
finable122213623fi_nable
findable14179023findable
fishable1637593fishable
fixable19218193fi_xable
getable101712553get_able
gettable11178133gettable
giftable1465893giftable
hatable121713963hat_able
hidable1399403hi_dable
hirable121612313hi_rable
imitable1239123imit_able
incitable13310433incit_able
kickable1535583kickable
killable14168133killable
kissable1436853kissable
knittable1544243knittable
liable81415813li__able
lienable10188693lienable
liftable1376863liftable
likable13219413li_kable
linable92214343li_nable
linkable14187263linkable
listable10810313listable
listenable1243653listenable
litigable1244223litigable
livable122010323li_vable
loveable13187903loveable
makeable1637253makeable
millable121710133millable
minable112315073mi_nable
miserable1349653miserable
missable12311533missable
mitigable1444753mitigable
mixable18259173mi_xable
moveable15168013moveable
mutable11312303mut_able
nameable1238863nameable
nettable101610243nettable
notable92114903not_able
outfable1378813outfable
pettable121710713pettable
pitiably1545843pitiably
potable112115363pot_able
priceable1546823priceable
raiseable1147243raiseable
ratable91717553rat_able
rateably1337783rateably
retable91820403ret_able
ridable101412493ri_dable
rinsable10310043rinsable
rippable1435383rippable
saleable10312023saleable
satiable10310733satiable
saveable1339003saveable
seeable91113943_seeable
singable11159543singable
sinkable14178413sinkable
sizable1839893si_zable
sizeably2244683sizeably
sliceable1345443sliceable
stable83921643_st_able
stateable1136903stateable
stewable1337133_stewable
suitable10310893suit_able
table75429603__t_able
takeable1437463takeable
tameable1238603tameable
tapeable1238823tapeable
tasteable1146123tasteable
teazle15329553__teazle
tenable93214493__tenable
tillable10159753tillable
tiltable10159013tiltable
timetable1346873timetable
tippable1435263tippable
totable92313363tot_able
tuneable1038913tuneable
typeable1535233typeable
untenable11410503untenable
useable9911063_useable
utterable1147153utterable
viable111613773vi__able
viewable1635223viewable
violable1337543violable
votable122111373vot_able
wadeable1437443wadeable
wettable13148043wettable
willable13168683willable
windable14159153windable
winnable13156983winnable
wirable121610963wi_rable
writable1338753writ_able

Search took 10 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.826216332.9
2DLD Change Limit1461621838.98616265.5
3Display Results1831830.0762407.9
 (SQL Overall)1786911839.88818071.5
 
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.