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

163 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
outfable137881(None) 
outfabled1595091outfabled
outfables1485561outfables
buffable1844392buffable
cuttable1247952cuttable
dutiable1137372dutiable
mutable11312302mut_able
outface123011972outfa_ce
outfall1039682outfa_ll
outfalls1138142outfalls
outfumble1642062outfumble
outgamble1492512outgamble
surfable1338442surfable
actable11313473act_able
affable15117403_affable
bitable11312203bit_able
biteable1237933biteable
bluffable1942063bluffable
boatable121610263boat_able
bootable12179223boot_able
boundable1444843boundable
burnable1237263burnable
buyable1437493bu_yable
citable11313463cit_able
citeable1238413citeable
countable1348853countable
culpable1436283culpable
curable112414513cu_rable
curbable1447663curbable
datable101714233dat_able
dateable1149443dateable
doubtable1445163doubtable
dupable12238383du_pable
durable102312723du_rable
eatable91717603eat_able
effable15106673_effable
fable105824753___fable
fittable1337093fittable
furlable1335893furlable
getable101712553get_able
gettable11178133gettable
giftable1465893giftable
guidable1236203guidable
gullable1136463gullable
gustable11138203gustable
hatable121713963hat_able
hateable1339373hateable
hittable1336853hittable
huggable1543333huggable
hummable1744583hummable
huntable1338093huntable
jumpable2143953jumpable
liftable1376863liftable
mountable1346303mountable
mutably1438613mut_ably
nettable101610243nettable
notable92114903not_able
obeyable1544113obeyable
obviable1543863obviable
openable1247013openable
operable12410323operable
outage72017533out_a_ge
outate62923403out_a_te
outbake13310773outba_ke
outbawl1237473outbawl_
outbawled1554953outbawled
outbawls1336053outbawls
outbye1147913out__bye
outcall9310123outca_ll
outcalls1038743outcalls
outcaste10119613outcaste
outdance11238733outdance
outdare83113403outda_re
outdate83016423outda_te
outdazzle1841803outdazzle
outfabling1644543outfabling
outfaced14219463outfaced
outfaces132311393outfaces
outfast101412123outfa_st
outfasted13147173outfasted
outfasts11117233outfasts
outfawn1335983outfa_wn
outfawned1644133outfawned
outfawns1434723outfawns
outfeel1037543outfeel_
outfeels1135063outfeels
outfelt10310603outf_elt
outfence1356973outfence
outfield1265253outfield
outfire1049713outf_ire
outflew1336423outf__lew
outfly1238273outf__ly
outfool1037333outfool_
outfooled1345493outfooled
outfools1136533outfools
outfumbled1841943outfumbled
outfumbles1741813outfumbles
outgambled1692333outgambled
outgambles1582363outgambles
outgave11259563outga_ve
outgaze17239223outga_ze
outhandle1374203outhandle
outhaul1039063outhaul_
outhauls1137223outhauls
outpace112613023outpa_ce
outrace92418553outra_ce
outrage82616893outra_ge
outraise8311933outraise
outrance102212783outrance
outrange92410223outrange
outrate72323183outra_te
outrave102614413outra_ve
outsail71411413outsail_
outsailed1037793outsailed
outsails8139863outsails
outsmile1046973outsmile
outsole71013433out_sole
outtake11310793outta_ke
outtalk1138233outta_lk
outvalue1144233outvalue
outwalk1437623outwa_lk
outwaste11147943outwaste
outwile10310263out_wile
overable13513573overable
ownable1237283o_wnable
oxidable1865123oxidable
pettable121710713pettable
pitiable1238293pitiable
portable12313203port_able
potable112115363pot_able
pourable1239133pou_rable
quotable1936493quotable
ratable91717553rat_able
rateable10311443rateable
reefable1339533reefable
retable91820403ret_able
ruinable1039263ruinable
rulable9310533ru_lable
rustable101511363rustable
satiable10310733satiable
sortable10312483sort_able
soundable1245983soundable
stable83921643_st_able
suable83920553su__able
suitable10310893suitable
summable1436903summable
table75429603__t_able
tithable1336853tithable
titrable1038963titrable
totable92313363tot_able
toteable1048353toteable
touchable1645023touchable
tubbable1134683tubbable
tunable92511313tu_nable
tuneable1038913tuneable
turnable1037853turnable
unable83819223_u_nable
usable84012553_u_sable
useable9911063_useable
vitiable1337503vitiable
votable122111373vot_able
voteable1347213voteable
wettable13148043wettable

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.733243780.4
2DLD Change Limit1461621637.89018525.0
3Display Results1631630.0762144.7
 (SQL Overall)1786911638.69920541.6
 
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.