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

144 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
fallouts113788(None) 
fallout10313501fallout_
allots64019172_allo_ts
bailouts1036612bailouts
ballots94116032ballo_ts
callous93516602callou_s
fadeouts1245692fadeouts
falloffs1343252falloffs
fallows133713972fallo_ws
flouts94315272f__louts
foldouts1244792foldouts
gallnuts943922gallnuts
galloots9268962galloots
gallous82813952gallou_s
pullouts1045222pullouts
rollouts8136732rollouts
sellouts837492sellouts
walkouts1544252walkouts
ablauts936083_ablauts
alliums957973_alliums
allods73615083_allo_ds
allot54933873_allo_t_
allows94517683_allo_ws
alloys94014563_allo_ys
allsorts844923_allsorts
backouts1698643backouts
bailout9414133bailout_
ballasts1037933ballasts
ballets93719513ball_ets
ballonets1146723ballonets
ballons93916963ballo_ns
balloons103110523balloons
ballot84624093ballo_t_
ballute938543ball_ute
ballutes1037523ball_utes
bullous9311663bullou_s
bullpouts1343193bullpouts
callants104112143callants
callets93821703call_ets
calloses10313393calloses
callouses1147683callouses
callus85317073call_u_s
campouts1436823campouts
clouts87017203__clouts
eelpouts1044323eelpouts
fabulous1344853fabulou_s
fadeout11410193fadeout_
faggots1234863faggo_ts
fagots1039963fa_go_ts
faitours1134263faitours
falconets1444813falconets
falcons1239123falco_ns
fallals103310193fall_als
fallers103917993fall_ers
falloff1245953fallo_ff
fallow124713853fallo__w
fallowed15127753fallowed
falls85727653fall___s
faltboats1444073faltboats
famous11412393fa_mou_s
fanworts1446103fanworts
fatuous1037783fatuou_s
faults94513553faul__ts
favours13437093fa_vours
felloes104114383fello_es
fellows134212433fello_ws
felworts1445953felworts
fillets103414753fill_ets
fillos94415083fillo__s
flameouts1443923flameouts
flavours1434693flavours
floats96816253f__loats
flours94414053f__lours
flout86226203f__lout_
foldout1149533foldout_
folious103710733foliou_s
follows13409923follo_ws
followups1742293followups
fulvous1334543fulvou_s
fylfots1642423fylfo_ts
galiots82311323galio_ts
gallants93310373gallants
gallets83517403gall_ets
galliots9228683galliots
galliums1145963galliums
gallnut847253gallnut_
gallons83015953gallo_ns
galloons9289703galloons
galloot82814223galloot_
gallops103211653gallo_ps
gallows113513513gallo_ws
gallus74313203gall_u_s
galoots82410793ga_loots
glouts74414713__glouts
halibuts1364443halibuts
halloas104318463hallo_as
halloes104021523hallo_es
halloos103716743hallo_os
hallos95425103hallo__s
hallot95426783hallo_t_
halloth134111253hallo_th
hallows134417393hallo_ws
handouts1238233handouts
hangouts1236183hangouts
haplonts1345773haplonts
harlots103413293harlo_ts
haylofts1783033haylofts
holdouts1245493holdouts
layouts1046483la_youts
louts56330273___louts
mahouts1237143ma_houts
maillots1037473maillo_ts
mallets93318493mall_ets
malleus92911313malleu_s
mallows123714323mallo_ws
pallets93919303pall_ets
palliums1236703palliums
pallors9314363pallo_rs
parlours1036153parlours
parlous9414293parlou_s
payouts1247303pa_youts
pullout9310593pullout_
ragouts838543ra_gouts
rainouts846913rainouts
reallots837993reallo_ts
rollout7811943rollout_
sallets73719653sall_ets
sallows103915553sallo_ws
sellout7313583sellout_
shallots11319503shallo_ts
takeouts1245363takeouts
talcous939483talcou_s
tallits73215993tall_its
tallols73311363tallo_ls
tallows103313743tallo_ws
thallous1136523thallou_s
valours10248743va_lours
villous102810023villou_s
walkout1447933walkout_
wallets103914833wall_ets
wallops123410413wallo_ps
wallows133613533wallo_ws
walnuts1033843wa_lnuts
washouts1445903washouts

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.860207780.2
2DLD Change Limit1461621447.93618417.6
3Display Results1441440.0463130.4
 (SQL Overall)1786911448.84220209.3
 
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.