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

136 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
assayers114484(None) 
assayer1035571assayer_
essayers1133561essayers
allayers11156632allayers
arrayers11125852arrayers
assailers943982assailers
assayed1135592assaye_d
assays977902assay__s
assuagers1043472assuagers
assumers1064962assumers
assurers866312assurers
essayer1033942essayer_
massagers1245512massagers
naysayers1542352naysayers
sayers94221592__sayers
slayers104513322_slayers
stayers103813632_stayers
swayers13398852_swayers
abasers95311973a_basers
abaters95115203a_baters
abraders1137343abraders
affrayers1842213affrayers
allayer10148213allayer_
amassers10337843amassers
annoyers1185033annoyers
answers1037043ans_wers
arrayer10136703arrayer_
ashlers10319583a_shlers
askers105915403a_s_kers
aspers86220313a_s_pers
aspirers1066493aspirers
assagais943813assagais
assailer844823assailer_
assails769093assa_ils
assais6711963assa__is
assaulters1042463assaulters
assaults843863assaults
assay8710283assay___
assaying1236003assaying
assenters967003assenters
assert64922583ass__ert
asserters956403asserters
asserts74311793ass__erts
asses55629283ass__e_s
assess65710463ass__ess
assets65617663ass__ets
assigners1044413assigners
assisters936353assisters
assizes1638453assize_s
assorters965743assorters
assuager944343assuager_
assuages936273assuage_s
assumer965363assumer_
assumes967163assume_s
assureds984493assureds
assurer767793assurer_
assures7611403assure_s
assurors894043assurors
asswages1255053asswage_s
asters65631603a_s_ters
belayers13298143belayers
bilayers13296923bilayers
brayers124511903_brayers
decayers14307963decayers
delayers12268663delayers
escapers12337413escapers
essayed1134013essaye_d
essays965653essay__s
flayers133912033_flayers
forayers14277273forayers
gainsayers1441873gainsayers
gassers84714633gass__ers
gossamers1243333gossamers
hayers124415943__hayers
inlayers1135643inlayers
issuers746123iss_uers
lassoers8338513lass_oers
layers93921183__layers
manslayers1542683manslayers
massacrers1442283massacrers
massacres1344693massacres
massager1136873massager_
massages1159883massage_s
masseters1136293masseters
misavers1348063misavers
mislayers1445943mislayers
naysayer1442583naysayer_
passades1139203passade_s
passages1139513passage_s
passers94717753pass__ers
passovers14144753passovers
payers114621823__payers
players124313763_players
prayers124212853_prayers
sabers85224733__sabers
sakers104125433__sakers
savers93825923__savers
sawers94620163__sawers
sawyers13317533_sawyers
sayeds10469253__sayeds
sayer84926553__sayer_
scalers93817263_scalers
scarers94618513_scarers
sealers74323553_sealers
seamers94719433_seamers
seaters74028943_seaters
shaders115915553_shaders
shakers144015563_shakers
shapers124016893_shapers
sharers104720623_sharers
shavers134115093_shavers
shyers124712203__shyers
skaters113512963_skaters
slakers114115753_slakers
slaters73123733_slaters
slavers103716503_slavers
slayer93916333_slayer_
snarers74216663_snarers
soakers114114953_soakers
soapers93715923_soapers
soarers74118093_soarers
spacers113813873_spacers
spaders104214473_spaders
sparers94519613_sparers
sprayers13367053sprayers
stagers84116673_stagers
starers74522313_starers
staters73922343_staters
stayer94516483_stayer_
strayers113510143strayers
swagers114211023_swagers
swayer125210973_swayer_
taxpayers2141893taxpayers
wassailers1342343wassailers
waylayers1842943waylayers
yeasayers1542023yeasayers

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.420425454.8
2DLD Change Limit1461621367.53319402.9
3Display Results1361360.0602266.7
 (SQL Overall)1786911368.01322300.1
 
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.