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

233 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
assails76909(None) 
assail6610151assail_
assais6711961assai_s
assoils776661assoils
wassails1145951wassails
abseils935972abseils
agnails837002agnails
assai5711542assai__
assailed945322assailed
assailer844822assailer
assailers943982assailers
assault747412assault
assaults843862assaults
assays977902assa_ys
assoil688542assoil_
avails939692a_vails
reassails945292reassails
resails74616742resails
sails55738102__sails
snails64816652_snails
spails84817822_spails
swails94913122_swails
vassals1057952vassa_ls
wassail1056132wassail_
aals49941143a__a_ls
abasias9711013abasias
abigails1143333abigails
abseil837183abseil_
abstains1047323abstains
aerials74017553aerials
affairs1334163affairs
agnail739533agnail_
ails45654723___ails
airmails1045273airmails
alcaics1137023alcaics
alkalis11148793alkalis
anils56326723a__nils
annals66415923anna_ls
anvils9219713a_nvils
apostils1046773apostils
appalls11337743appalls
appals104812943appa_ls
apsis75718293aps_i_s
archils12510533archils
argalis84214193argalis
argals75517713arga_ls
argils75213623a_rgils
arils58732203a__rils
arshins10312573arshins
arsis55722423ars_i_s
asanas6514113a_sanas
ascarids11438503ascarids
ascaris93613323ascaris
asdics9439863a_sdics
ashfalls1443433ashfalls
asocials1075683asocials
aspics104211563a_spics
aspis74618143a_spi_s
asramas938303asramas
assagai843903assagai
assagais943813assagais
assailant944383assailant
assailants1052863assailants
assailing1036023assailing
assassins843933assassins
assay8710283assa__y
assayed1135593assayed
assayer1035573assayer
assayers1144843assayers
assaying1236003assaying
assegais943953assegai_s
assents74512223assents
asserts74311793asserts
asses55629283ass__es
assess65710463ass_ess
assets65617663ass_ets
asshole1046793asshole
assholes1146743assholes
assign736783ass_ign
assigns836193assigns
assist6314603ass_ist
assists738473assists
assize1538633ass_ize
assizes1638453assizes
asslike1137373asslike
assoiled935023assoiled
assorts73310153assorts
assuages936273assuages
assumes967163assumes
assures7611403assures
asswages1255053asswages
astasias8410143astasias
astrals75515243astrals
atlatls744773atlatls
attains7310983attains
avail8313883a_vail_
awaits96411953a_waits
axils127217503a__xils
bails75933523__bails
basils85717473bas_ils
bewails1277553bewails
brails84621293_brails
brasils9410973brasils
camails11311753camails
cassabas1245733cassabas
cassatas1036683cassatas
cassavas1344803cassavas
cassias93514343cass_ias
cassis84818853cass_i_s
casuals91410543casua_ls
cattails1038553cattails
causals91411183causa_ls
dassies84418663dass_ies
derails84216393derails
details84214043details
distils83015803distils
dossals8379303dossa_ls
dossils8669773dossils
drails74716953_drails
emails84412343_emails
entails7912823entails
espials937093espials
essays965653essa_ys
essoins737603essoins
fails85631483__fails
fantails1139693fantails
flails94313003_flails
fossils10379013fossils
frails93716473_frails
fusains1038363fusains
fusils93912343fus_ils
gassily1137813gass_ily
grails77518783_grails
hails85231643__hails
hassels104311023hass_els
headsails1343943headsails
instils7811453instils
isseis638563issei_s
jails125422943__jails
jassids1586143jass_ids
jezails2334163jezails
kails95525223__kails
lassies74420103lass_ies
lassis65216703lass_i_s
lugsails942743lugsails
mails76037783__mails
mainsails1144853mainsails
massages1159883massages
massas85116463massa__s
massifs1237743mass_ifs
misaims11310113misaims
missals93914433missa_ls
mosaics1138073mosaics
nails55730403__nails
nasals63312463nasa_ls
osseins736133osseins
outsails8139863outsails
oxtails1436383oxtails
pails75833063__pails
parasails1147593parasails
pascals11610013pasca_ls
pasquils1943123pasquils
passable12310633passable
passably1537253passably
passades1139203passades
passados1146303passados
passages1139513passages
passels93913023pass_els
pastils94416173pastils
pistils93314303pistils
quails153412643_quails
rails55937403__rails
rascals959663rasca_ls
rattails837133rattails
reassail845753reassail_
remails94714563remails
renails74917263renails
resail64418733resail_
retails74718973retails
sabals84618863saba_ls
saids65328863__saids
sail45447163__sail_
sains55639973__sains
salals65120083sala_ls
sals46851673__sa_ls
sasins64923103sas_ins
sassabies1144153sassabies
sassies74719263sassies
sassily1038723sassily
sauls55128123__sauls
scalls84218203_scalls
seals54839703_sea_ls
serails73318363serails
shauls94913113_shauls
shawls125411973_shawls
sials54227243_sia_ls
sigils73912363_sigils
sisals63013573sisa_ls
skysails1552493skysails
smalls84514123_smalls
snail57020203_snail_
snarls64016873_snarls
soils55327983__soils
spail74921553_spail_
spaits85017473_spaits
spalls84217343_spalls
speils84116223_speils
spoils84614533_spoils
staigs75414813_staigs
stains64923653_stains
stairs65416333_stairs
stalls64019933_stalls
staysails1242853staysails
swail86217163_swail_
swains94513953_swains
tahsils1035053tahs_ils
tails55634193__tails
tarsals72512603tarsa_ls
tassels74510853tass_els
tassies74918933tass_ies
tenails73713923tenails
topsails1075093topsails
trails64622513_trails
trysails1144163trysails
unnails738223unnails
usuals637793usua_ls
vails85825933__vails
vassal979243vassa_l_
wagtails1244443wagtails
wails86631483__wails
wassailed1343153wassailed
wassailer1242783wassailer
wassailers1342343wassailers

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.436409841.7
2DLD Change Limit1340272336.37621020.5
3Display Results2332330.0932505.4
 (SQL Overall)1786912336.90525878.5
 
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.