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

150 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
outfalls113814(None) 
outcalls1038741outcalls
outfall1039681outfall_
catfalls1347062catfalls
footfalls1544592footfalls
nutgalls943952nutgalls
outbawls1336052outbawls
outcall9310122outcall_
outfable1378812outfable
outfables1485562outfables
outfaces132311392outfaces
outfasts11117232outfasts
outfawns1434722outfawns
outfeels1135062outfeels
outfools1136532outfools
outhauls1137222outhauls
outkills1245142outkills
outpolls1046212outpolls
outpulls1065442outpulls
outrolls847822outrolls
outsails8139862outsails
outsells888652outsells
outtalks1236502outtalks
outtells896852outtells
outwalks1535992outwalks
outwills1135652outwills
outyells11105302outyells
pitfalls1345372pitfalls
ashfalls1443433ashfalls
befalls12349123_befalls
buffalos1642863buffalos
buttals938503butta_ls
catcalls1238323catcalls
catfall1237393catfall_
dewfalls1543073dewfalls
downfalls1643143downfalls
falls85727653___falls
footballs1445363footballs
footfall1444823footfall_
footwalls1544383footwalls
fulfills1443653fulfills
gumballs1345313gumballs
icefalls1344253icefalls
infalls1038943_infalls
mutually1345203mutually
mutuals937133mutua_ls
nutgall844443nutgall_
oddballs1242963oddballs
offals1235893o_ffa_ls
outacts9310213out_acts
outadds936203out_adds
outages82317323out_ages
outasks1138173out_asks
outbacks1638983outbacks
outbakes1439993outbakes
outbarks1437833outbarks
outbawl1237473outbawl_
outbrawls1443483outbrawls
outbulks1444763outbulks
outbully1345103outbully
outcasts10108683outcasts
outcavils1443233outcavils
outclass1037203outclass
outcrawls1443513outcrawls
outdares92712463outdares
outdates93114743outdates
outduels945053outduels
outearns838403outearns
outeats72215703outea_ts
outfabled1595093outfabled
outface123011973outfa_ce
outfaced14219463outfaced
outfast101412123outfa_st
outfawn1335983outfa_wn
outfeasts12114333outfeasts
outfeel1037543outfeel_
outfelt10310603outf_elt
outfield1265253outfield
outfields1373123outfields
outfinds1235643outfinds
outfires1139863outfires
outfits102210833outf_its
outflank1544593outflank
outflanks1643233outflanks
outflew1336423outf_lew
outflies11310153outflies
outflow1355353outf_low
outflows1445463outflows
outfly1238273outf__ly
outfool1037333outfool_
outfoots1136883outfoots
outfoxes1836743outfoxes
outgains9810163outgains
outgallop1241743outgallop
outgallops1351213outgallops
outgas7313203outga__s
outgazes18248713outgazes
outhaul1039063outhaul_
outhowls1445723outhowls
outkill1136553outkill_
outlands988563outlands
outlasts8108713outlasts
outlaws10249603outla_ws
outlays102610903outla_ys
outmans92413283outma_ns
outpaces122411943outpaces
outpass939713outpa_ss
outplans10259533outplans
outplays13246843outplays
outpoll946793outpoll_
outpull956443outpull_
outraces102217863outraces
outrages92215933outrages
outranks12298823outranks
outrates82421373outrates
outraves112313833outraves
outroll749303outroll_
outsail71411413outsail_
outsays102710403outsa_ys
outsell7109263outsell_
outsmells1194103outsmells
outsoles8813113outsoles
outspells11104603outspells
outsulks1244993outsulks
outtakes12310033outtakes
outtalk1138233outta_lk
outtasks1235633outtasks
outtell797883outtell_
outvalue1144233outvalue
outvalues1244303outvalues
outwaits1137493outwaits
outwalk1437623outwa_lk
outwards1299123outwards
outwars10912793outwa_rs
outwiles1139233outwiles
outwill1037323outwill_
outyell1095843outyell_
outyelps1393073outyelps
overalls11410393overalls
oxtails1436383oxt_ails
pitfall1245823pitfall_
pratfalls1443863pratfalls
puffballs1941933puffballs
refalls103312243_refalls
rockfalls1843183rockfalls
shortfalls1652913shortfalls
softballs1443773softballs
sourballs1145233sourballs
stalls64019933_st_alls
talls55133433__t_alls

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621506.64022012.3
3Display Results1501500.0632381.0
 (SQL Overall)1786911507.14325016.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.