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

128 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
assailed94532(None) 
assailer844821assailer
assoiled935021assoiled
wassailed1343151wassailed
abseiled1144732abseiled
assail6610152assail__
assailers943982assailers
assails769092assail_s
assaulted1042582assaulted
assayed1135592assa_yed
availed1135972a_vailed
reassailed1143332reassailed
resailed93613062resailed
sailed74327762__sailed
snailed83811922_snailed
unassailed1142912unassailed
wassailer1242782wassailer
abscised1364133abscised
abstained1245053abstained
ailed66240283___ailed
airmailed1242903airmailed
aisled74516183ais__led
ansated84214003ansa_ted
anviled1138953a_nviled
appalled1344813appalled
ariled75620323a__riled
ascared10399523asca_red
ascribed1374693ascribed
ashamed1336243asha_med
aspired1068173a_spired
assagaied1142173assagaied
assai5711543assai___
assailant944383assailant
assailing1036023assailing
assais6711963assai__s
assault747413assaul_t
assaulter942753assaulter
assaults843863assaults
assayer1035573assa_yer
assegaied1142503assegai_ed
assembled1443693assembled
assented957513assented
asserted957903asserted
assessed945023assessed
asshole1046793asshole_
assholes1146743assholes
assigned1044633assigned
assisted936233assisted
assize1538633ass_ize_
assizes1638453ass_izes
asslike1137373asslike_
assoil688543assoil__
assoils776663assoil_s
assorted956603assorted
assuaged1044383assuaged
assumed1065293ass_umed
assured858373ass_ured
asswaged1343333asswaged
attained997353attained
awaited1146963a_waited
bailed94726653__bailed
besmiled1335503besmiled
bewailed1435343bewailed
brailed103914013_brailed
camailed1336553camailed
derailed102410403derailed
detailed10319873detailed
disabled1248713disabled
emailed10359213_emailed
ensiled82611433ens_iled
entailed989523entailed
essayed1134013essa_yed
failed105421603__failed
fantailed1345563fantailed
flailed1137303_flailed
hailed104122743__hailed
hassled11358303hass__led
jailed144917423__jailed
mailed95326753__mailed
massacred1443193massacred
massaged1236753massa_ged
misaimed1338093misaimed
misfiled14278653misfiled
nailed74021493__nailed
outsailed1037793outsailed
parasailed1344073parasailed
passable12310633passable_
passaged1236243passa_ged
quailed1737823_quailed
railed74727543__railed
rassled83310453rass__led
rattailed1084213rattailed
remailed112411403remailed
renailed92512803renailed
resiled84621983res_iled
retailed94113963retailed
sailer63526103__sailer
sained75424243__sained
scaled94822443_sca_led
sealed74328363_sea_led
shaled105023953_sha_led
shauled1148793_shauled
shawled1437773_shawled
smiled93716433__smiled
snarled83612363_snarled
soiled73822473__soiled
spalled103113133_spalled
speiled104412123_speiled
spiled94621993__spiled
spoiled104811353_spoiled
stabled103514953_stabled
stained84215343_stained
staled74728103_sta_led
stalled83515693_stalled
stapled103613703_stapled
tailed74424663__tailed
tasseled935603tass_eled
tasselled1044663tasselled
trailed83415673_trailed
unhailed12219963unhailed
unmailed11229763unmailed
unnailed9229443unnailed
unsoiled92412083unsoiled
vailed104619293__vailed
wailed104823593__wailed
wassail1056133wassail__
wassailers1342343wassailers
wassails1145953wassail_s

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.406440125.6
2DLD Change Limit1461621287.92018454.8
3Display Results1281280.0462782.6
 (SQL Overall)1786911288.37221343.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.