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

354 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
fallows13371397(None) 
allows94517681_allows
fallow124713851fallow_
fellows134212431fellows
follows13409921follows
gallows113513511gallows
hallows134417391hallows
mallows123714321mallows
sallows103915551sallows
tallows103313741tallows
wallows133613531wallows
allods73615082_allods
allots64019172_allots
allow85420662_allow_
alloys94014562_alloys
ballons93916962ballons
ballots94116032ballots
barlows12259982barlows
bellows124313302bellows
billows123611292billows
callous93516602callous
callow114714662callow_
falcons1239122falcons
fallals103310192fallals
fallers103917992fallers
falloff1245952falloff
falloffs1343252falloffs
fallout10313502fallout
fallouts1137882fallouts
fallowed15127752fallowed
falls85727652fall__s
farrows13259792farrows
felloes104114382felloes
fellow123712742fellow_
fillos94415082fillo_s
flows115822362f__lows
follow124010352follow_
gallons83015952gallons
gallops103211652gallops
gallous82813952gallous
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallow124818322hallow_
hollows134412332hollows
mallow114014742mallow_
mellows123812232mellows
pallors9314372pallors
pillows122610122pillows
sallow94315752sallow_
sallowy13369342sallowy
shallows14388862shallows
swallows14295892swallows
tallols73311362tallols
tallow93714202tallow_
tallowy13347632tallowy
wallops123410412wallops
wallow123913512wallow_
willows13299752willows
yellows13329602yellows
aglow94711973_aglow_
aldols7109713_aldols
algors7312553_algors
allays94313743_allays
allees64521483_allees
alleys95113303_alleys
allies63827673_allies
allod64418383_allo_d
allot54933873_allo_t
allowed111610083_allowed
alloy85519973_allo_y
alls46740923_all__s
allyls9437273_allyls
aloes54933673_a_loes
alow75328593_a_low_
altos55822953_alto_s
arrows92813493_arrows
avows114910983_a_vows
azlons154110423_azlons
bailors93212413bailors
balboas113710073balboas
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
balls76236413ball__s
barlow112911433barlow_
barrows123411693barrows
bellow114213353bellow_
belows114614183_belows
billons93013363billons
billow114111223billow_
billowy15366903billowy
blows105423833__blows
bullous9311663bullous
cahows14399123ca_hows
callans94518473callans
callas84526753call_as
callboys1585183callboys
callees94117783callees
callers94221963callers
callets93821703callets
callose9313663callose
calloses10313393calloses
callower13159073callower
callowest1445823callowest
calls75634733call__s
callus85317073call_us
calos74431903ca_lo_s
cellos84517803cello_s
collops112611753collops
dalles74222063dall_es
dallies84023193dallies
daltons8310403daltons
dayglows1641953dayglows
disallows1343393disallows
dollops10287963dollops
elbows1196723_elbows
fablers124812613fablers
fables114921673fabl_es
fabulous1344853fabulous
factors12912133factors
fados95620733fa_do_s
faggots1234863faggots
fagots1039963fa_gots
failles102914133failles
fails85631483fail__s
falces115216003fa_lces
falcon11310293falco_n
fall75535313fall___
fallacy1536433fallacy
fallal93612693fall_al
fallaway1743903fallaway
fallaways1843163fallaways
fallen93813373fall_en
faller94621233fall_er
fallfish1744463fallfish
falling113621583falling
fallowing1666433fallowing
fallowness1642943fallowness
falsies103515013falsies
falters103916473falters
famous11412393fa_mous
fandoms13229473fandoms
fanions103713073fanions
fanons96115213fa_nons
fanos85926503fa_no_s
fantods11177623fantods
fantoms12189153fantoms
farles96025783farl_es
farls85731113farl__s
faros85532023fa_ro_s
farrow12309983farrow_
fathoms1537523fathoms
fatless103212203fatless
fatsoes10379423fatsoes
fatsos9389423fatso_s
fatuous1037783fatuous
faulds10438963faul_ds
faults94513553faul_ts
favors124211403fa_vors
fellahs13428393fellahs
fellas95116963fell_as
fellers104117543fellers
fellies104119743fellies
felloe93513923fello_e
fellowed15136843fellowed
fellowly17264093fellowly
fells85327383fell__s
felons93615763f_elons
fillers104320213fillers
filles94224523fill_es
fillets103414753fillets
fillies103420253fillies
fillips12298133fillips
fillo84319783fillo__
fills84632373fill__s
filos86125383f_ilo_s
flacons1238053flacons
flagons1137973flagons
flavors1337293flavors
flaws115920343f__laws
flews115316443f__lews
flocs105519233f__locs
floes85528143f__loes
flogs95919963f__logs
floods104511653f_loods
floors94112353f_loors
flops105920143f__lops
floss85118263f__loss
flow105924923f__low_
flown116213993f__lown
fluors94311373f_luors
flyblows1942013flyblows
fogbows1643853fogbows
folios93915463folio_s
folious103710733folious
folles93820473foll_es
follies103618943follies
follis93113903foll_is
followed15146273followed
follower14137073follower
followers15146183followers
followup1642173followup
followups1742293followups
frows116623103f__rows
fullams1236553fullams
fullers103817373fullers
fulls84623523full__s
fulvous1334543fulvous
furrows13327793furrows
fylfots1642423fylfots
galiots82311323galiots
galleons9258443galleons
gallets83517403gallets
galleys11369713galleys
gallies84122713gallies
galliots9228693galliots
gallon73715813gallo_n
galloon82910643galloon
galloons9289703galloons
galloot82814223galloot
galloots9268963galloots
gallop93311383gallo_p
gallowses1374953gallowses
galls64729323gall__s
gallus74313203gall_us
galoots82410793galoots
galops94712623ga_lops
glows95518033__glows
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hallo__
halloa94918123hallo_a
halloed113314913halloed
halloo95118973hallo_o
hallot95426783hallo_t
halloth134111253halloth
hallowed15179503hallowed
hallower14139823hallower
hallowers15137723hallowers
halls85633783hall__s
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
harlots103413293harlots
harrows132611043harrows
haymows1883813haymows
helloes103717473helloes
hellos95321683hello_s
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollow124212663hollow_
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
inflows1335523inflows
jailors14328753jailors
jalops15329593ja_lops
jellos134714283jello_s
lallans74113543lallans
lalls55324133lall__s
lollops9227443lollops
lows75843013___lows
maillots1037473maillots
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
malls76233433mall__s
maltols939403maltols
marrows122911833marrows
mellow114112223mellow_
narrows10258853narrows
pallets93919303pallets
pallor8313683pallo_r
palls74332563pall__s
parlors9312923parlors
parlous9414293parlous
pillow113110573pillow_
pillowy15316423pillowy
plows105419903__plows
rallies73823343rallies
rallyes10348553rallyes
reallots837993reallots
reflows13258983reflows
reglows11288843reglows
replows12329703replows
sailors73213723sailors
salchows1644203salchows
sallets73719653sallets
sallies73227813sallies
sallowed12149033sallowed
sallower11139503sallower
sallowest1246563sallowest
sallowish1544943sallowish
sallowly14344833sallowly
salmons93713263salmons
salols64017873sa_lols
salons63823693sa_lons
saloons74415323saloons
saloops93510133saloops
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
sawlogs1135393sawlogs
scallops12297393scallops
shallops13288323shallops
shallots11319503shallots
shallow13388873shallow_
slaloms9106543slaloms
slows85323463__slows
swallow13355753swallow_
tailors73212393tailors
talcous939483talcous
talions7314113talions
tallboys1374623tallboys
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallol63612223tallo_l
tallowed12157713tallowed
talls55133433tall__s
talons64019443ta_lons
thallous1136523thallous
unhallows15122123unhallows
upflows1543513upflows
valleys13407483valleys
valors93413773va_lors
villous102810023villous
wallahs13409473wallahs
wallas95719393wall_as
wallets103914833wallets
wallies103320743wallies
wallop113310293wallo_p
wallowed15148173wallowed
wallower14158943wallower
wallowers15127653wallowers
walls85529383wall__s
willow12369693willow_
willowy16276353willowy
yarrows13277863yarrows
yellow12429883yellow_
yellowy16255693yellowy

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273546.03322215.6
3Display Results3543540.1232878.0
 (SQL Overall)1786913546.56227231.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.