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 “sealers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
sealers7432355(None) 
dealers84118611dealers
healers104319461healers
scalers93817261scalers
sealer63928961sealer_
sealery104011051sealery
seamers94719431seamers
seaters74028941seaters
sellers73721321sellers
stealers83412211stealers
vealers103214291vealers
balers85626932_balers
beaders104120182beaders
beakers134216872beakers
bearers94619592bearers
beaters94925042beaters
beavers124417322beavers
ceilers93912532ceilers
coalers94419352coalers
dealer74122142dealer_
dialers83614302dialers
eagers74523682_eagers
eaters65535952_eaters
fearers104815272fearers
feelers103814742feelers
fellers104117542fellers
halers94926912_halers
headers113819392headers
healer94221802healer_
heapers123616672heapers
hearers104319782hearers
heaters104225222heaters
heavers133717192heavers
heelers103815622heelers
hellers103619832hellers
keglers12277772keglers
leaders83819602leaders
leakers113415422leakers
leaners73718172leaners
leapers93716662leapers
leasers74717842leasers
leavers103717782leavers
meaners94415242meaners
mewlers12288982mewlers
pearlers1039032pearlers
pedalers11239392pedalers
pedlers103013272pedlers
peelers93615592peelers
readers83823772readers
realer63528592realer_
reales64934122reale_s
realters83614042realters
reamers94221082reamers
reapers93520452reapers
rearers74323562rearers
reavers108320742reavers
reelers73520272reelers
regalers94311132regalers
sabers85224732s_abers
sailers73822322sailers
sakers104125432s_akers
saleps85014902s_aleps
sales56055592s_ale_s
salters73622252s_alters
salvers103916002s_alvers
savers93825922s_avers
sawers94620162s_awers
sayers94221592s_ayers
scalars93711902scalars
scaler84321602scaler_
scales84529312scale_s
scalpers123710862scalpers
scarers94618512scarers
seabeds10417222seabeds
sealed74328362seale_d
sealeries9313132sealeries
seals54839702seal__s
seamer84223612seamer_
seamless10238722seamless
searer65432022searer_
sears54744912sea__rs
seater64534162seater_
seatless83213002seatless
seders74420282se_ders
seeders83017112seeders
seekers113712332seekers
seemers93814332seemers
seers55136382se__ers
seiners74219272seiners
seisers73816392seisers
seizers164112502seizers
seller63824602seller_
selles64426982selle_s
senders83022352senders
sergers83815632sergers
servers103214832servers
setters73822062setters
settlers8289022settlers
severs94121122se_vers
sewers94719722se_wers
sexless1467242sexless
shaders115915552shaders
shakers144015562shakers
shales94731252shale_s
shapers124016892shapers
sharers104720622sharers
shavers134115092shavers
shearers113911322shearers
shellers112812582shellers
sidlers83414232sidlers
sillers73822102sillers
skaters113512962skaters
slakers114115752slakers
slaters73123732slaters
slavers103716502slavers
slayers104513322slayers
smearers10308622smearers
smellers10329772smellers
smilers94113852smilers
snarers74216662snarers
snarlers8298752snarlers
sneakers12308642sneakers
soakers114114952soakers
soapers93715922soapers
soarers74118092soarers
spacers113813872spacers
spaders104214472spaders
spales84728102spale_s
spallers102910732spallers
sparers94519612sparers
speakers14299452speakers
spearers103711142spearers
spellers102812762spellers
squealers1894452squealers
stablers103611152stablers
stagers84116672stagers
staler64025822staler_
stales65538292stale_s
stalkers12369852stalkers
staplers103111202staplers
starers74522312starers
staters73922342staters
stayers103813632stayers
stealer72913982stealer_
steamers103410872steamers
stylers10359352stylers
sutlers73116972sutlers
swagers114211022swagers
swales93920762swale_s
swayers13398852swayers
swearers11328582swearers
sweaters113811062sweaters
talers64628142_talers
tearers75218232tearers
teasers75317242teasers
tellers73717602tellers
thalers106212262thalers
vealer94016542vealer_
veilers103911822veilers
walers94824462_walers
weaners104613832weaners
wearers104615902wearers
weavers133714462weavers
whalers13529702whalers
yellers103912952yellers

Search took 5 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 Filter1786911076710.390458182.1
2DLD Change Limit1076711653.53330475.8
3Display Results1651650.0632619.0
 (SQL Overall)1786911653.98644829.7
 
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.