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

204 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
sallowy1336934(None) 
sallow94315751sallow_
sallowly14344831sallowly
sallows103915551sallows
tallowy13347631tallowy
allow85420662_allow_
allows94517682_allows
alloy85519972_allo_y
billowy15366902billowy
callow114714662callow_
fallow124713852fallow_
fallows133713972fallows
gallows113513512gallows
hallow124818322hallow_
hallows134417392hallows
mallow114014742mallow_
mallows123714322mallows
pillowy15316422pillowy
sallowed12149032sallowed
sallower11139502sallower
sally85129712sall__y
shallow13388872shallow_
shallowly1842612shallowly
shallows14388862shallows
swallow13355752swallow_
swallows14295892swallows
tallow93714202tallow_
tallows103313742tallows
wallow123913512wallow_
wallows133613532wallows
willowy16276352willowy
yellowy16255692yellowy
aglow94711973_aglow_
alkoxy2033343_alkoxy
allay85620393_all_ay
alley85721673_all_ey
allod64418383_allo_d
allods73615083_allods
allonym1244733_allonym
allot54933873_allo_t
allots64019173_allots
allowed111610083_allowed
alloys94014563_alloys
ally76935643_all__y
alow75328593_a_low_
arrowy12288273_arrowy
balcony1435853balcony
ballon84117493ballo_n
ballons93916963ballons
balloon93711433balloon
ballot84624093ballo_t
ballots94116033ballots
ballsy11508873ball_sy
bally105530103ball__y
barlow112911423barlow_
barlows12259973barlows
bellow114213353bellow_
bellows124313303bellows
billow114111223billow_
billows123611293billows
blowy134315323__blowy
callboy1465833callboy
callose9313663callose
callous93516603callous
callower13159073callower
calory11312843ca_lory
dally95324743dall__y
disallow1243513disallow_
disallows1343393disallows
fallacy1536433fallacy
fallaway1743903fallaway
falloff1245953falloff
fallout10313503fallout
fallowed15127753fallowed
fellow123712743fellow_
fellowly17264093fellowly
fellows134212433fellows
follow124010353follow_
follows13409923follows
gallery11468743gallery
galley104215453gall_ey
gallfly1433523gallfly
gallon73715813gallo_n
gallons83015953gallons
galloon82910643galloon
galloot82814223galloot
gallop93311383gallo_p
gallops103211653gallops
gallous82813953gallous
gally95026173gall__y
hallo85127553hallo__
halloa94918123hallo_a
halloas104318463halloas
halloed113314913halloed
halloes104021523halloes
halloo95118973hallo_o
halloos103716743halloos
hallos95425103hallo_s
hallot95426783hallo_t
halloth134111253halloth
hallowed15179493hallowed
hallower14139813hallower
hallway1636173hallway
hollow124212663hollow_
hollowly1743383hollowly
hollows134412333hollows
jalopy18325863ja_lopy
lollopy12234773lollopy
marrowy15236083marrowy
mellow114112223mellow_
mellowly16254003mellowly
mellows123812233mellows
pallor8313673pallo_r
pallors9314363pallors
pally105727123pall__y
pillory12247453pillory
pillow113110573pillow_
pillows122610123pillows
psalmody1642093psalmody
rally84725903rall__y
sadly94519123sadl__y
sailor63113753sailo_r
sailorly1143543sailorly
sailors73213723sailors
salably121610743salably
salary9515213sa_lary
salchow1544323salchow_
salchows1644203salchows
salify12311373sa_lify
sall44544683sall___
sallet63734543sall_et
sallets73719653sallets
sallied83316953sallied
sallier73320423sallier
sallies73227813sallies
sallowest1246563sallowest
sallowing1357383sallowing
sallowish1544943sallowish
salmon84614183salmo_n
salmons93713263salmons
salol55222143sa_lo_l
salols64017873sa_lols
salon55228553sa_lo_n
salons63823693sa_lons
saloon64418023sa_loon
saloons74415323saloons
saloop84212583sa_loop
saloops93510133saloops
salsify1334703salsify
saltily10310543saltily
salty85524383sa_l_ty
salvo84415643salvo__
salvoed11307063salvoed
salvoes102811313salvoes
salvor94711093salvo_r
salvors103910913salvors
salvos94613383salvo_s
saveloy1334663savelo_y
savory124310563sa_vory
savoy114713883sa_vo_y
sawlog1035793sawlo_g
sawlogs1135393sawlogs
saxony1636233sa_xony
scallop11237643scallo_p
scallops12297393scallops
selloff1345923selloff
sellout7313583sellout
shadowy1744723shadowy
shalloon1145683shalloon
shallop12348453shallo_p
shallops13288323shallops
shallot103614133shallo_t
shallots11319503shallots
shallowed1655083shallowed
shallower1555673shallower
showy145714013s__howy
sillily10209783sillily
silly84527623sill__y
slalom888173slalo_m
slaloms9106543slaloms
slow77729493s__low_
slowly1237153s__lowly
slows85323463s__lows
snowy115011563s__nowy
sully84622903sull__y
swallowed1663583swallowed
swallower1554333swallower
tallboy1265143tallboy
tallol63612223tallo_l
tallols73311363tallols
tallowed12157713tallowed
tally84526863tall__y
valley124311603vall_ey
wallaby1535073wallaby
wallop113310293wallo_p
wallops123410413wallops
wallowed15148163wallowed
wallower14158933wallower
wally114625093wall__y
willow12369693willow_
willows13299753willows
yellow12429883yellow_
yellowly17283623yellowly
yellows13329603yellows

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272047.17018692.7
3Display Results2042040.0802550.0
 (SQL Overall)1786912047.64023388.9
 
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.