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

82 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
outfables148556(None) 
outfable1378811outfable_
outfabled1595091outfabled
outfaces132311392outfa_ces
outfalls1138142outfa_lls
outfumbles1741812outfumbles
outgambles1582362outgambles
buffable1844393buffable_
burnables1344003burnables
cuttable1247953cuttable_
durables11237013du_rables
dutiable1137373dutiable_
eatables10169793eat_ables
fables114921673___fables
giftables1572593giftables
gustables12165223gustables
mutable11312303mut_able_
notables10178243not_ables
outages82317323out_a_ges
outbakes1439993outba_kes
outbawled1554953outbawled
outbawls1336053outbawl_s
outbless1037963out__bless
outcalls1038743outca_lls
outcastes11118913outcastes
outdances12198503outdances
outdares92712463outda_res
outdates93114743outda_tes
outdazzles1951713outdazzles
outfabling1644543outfabling
outface123011973outfa_ce_
outfaced14219463outfa_ced
outfall1039683outfa_l_l
outfasted13147173outfasted
outfasts11117233outfa_sts
outfawned1644133outfawned
outfawns1434723outfa_wns
outfeels1135063outfeel_s
outfences1456463outfences
outfields1373123outfields
outfires1139863outf_ires
outfishes15118023outfishes
outflew1336423outf__lew
outflies11310153outf_lies
outfooled1345493outfooled
outfools1136533outfool_s
outfoxes1836743outf_oxes
outfumble1642063outfumble_
outfumbled1841943outfumbled
outgamble1492513outgamble_
outgambled1692333outgambled
outgasses1036663outgasses
outgazes18248713outga_zes
outhandles1473653outhandles
outhauls1137223outhaul_s
outpaces122411943outpa_ces
outpasses1146613outpasses
outraces102217863outra_ces
outrages92215933outra_ges
outraises9311023outraises
outrances112912113outrances
outranges102510013outranges
outrates82421373outra_tes
outraves112313833outra_ves
outsailed1037793outsailed
outsails8139863outsail_s
outsmiles1146443outsmiles
outsoles8813113out_soles
outtakes12310033outta_kes
outtalks1236503outta_lks
outvalues1244303outvalues
outwalks1535993outwa_lks
outwashes15116183outwashes
outwastes12127693outwastes
outwiles1139233out_wiles
portables1337873port_ables
potables12179703pot_ables
ratables10159723rat_ables
retables101712673ret_ables
stables93219073_st_ables
surfable1338443surfable_
tables84524893__t_ables

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.423422437.4
2DLD Change Limit148641827.08020994.5
3Display Results82820.0302733.3
 (SQL Overall)178691827.53323721.1
 
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.