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

251 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
nauseas73599(None) 
nausea637311nausea_
anuses66218772anuse_s
causers94014792causers
causes88026472cause_s
causeys12387222causeys
hausens1077632hausens
nauseant845742nauseant
nauseants943052nauseants
nauseate845892nauseate
nauseates946212nauseates
nauseous844832nauseous
nouses64627162nouse_s
pausers94113222pausers
pauses84621472pause_s
abusers94710553abusers
abuses85119103abuse_s
amusers94610193amusers
amuses85117943amuse_s
amusias938583amusias
anises64826693anise_s
ankuses1148203ankuse_s
anurias7312253anurias
apneas83211383_apneas
apses76823913_apse_s
areas55935773_a_reas
arses55733873_arse_s
asea46327183_a_sea_
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
augers73818703_augers
auras55932563_au_ras
aures55137093_aure_s
aureus65314883_aureus
baases85218013baase_s
balsas86417523bals_as
bases75644353ba_se_s
basses85428303basse_s
bassets96414823bassets
baubees11348713baubees
bouses84931783bouse_s
buses75936013_buse_s
calesas9411833calesas
carses85233653carse_s
casas75327843ca_s_as
casease939323ca_sease
cases75048383ca_se_s
cassenas10317483cassenas
cassias93514343cassias
caules85927253caule_s
causal81413203caus_al
causals91411183causals
cause75225353cause__
caused95117043cause_d
causer84117783cause_r
causeway1643253causeway
causeways1742743causeways
causey113513273cause_y
cayuses12188403cayuse_s
clauses93813323clause_s
cruses88127713cruse_s
crusets93811043crusets
cusecs10509153_cusecs
daises74318983daise_s
damsels10126703damsels
daubers104610423daubers
daubes94913703daube_s
dousers84817273dousers
douses74928933douse_s
druses75517253druse_s
easels65914553ea_sels
eases56041613ea_se_s
fauces114916153fauce_s
faucets12578443faucets
faunas94013633fau_nas
fauves125610423fauve_s
favuses1336183favuse_s
fusees95416403_fusees
fusels94412453_fusels
fuses85628423_fuse_s
galeas74618513ga_leas
gases65633993ga_se_s
gassers84714633gassers
gasses75724783gasse_s
gaugers94211713gaugers
gauges85915993gauge_s
gauss65613453gaus__s
gausses8308693gausses
gauzes164710633gauze_s
hansas94616043hans_as
hansels104011653hansels
hanses95022633hanse_s
hassels104311013hassels
haulers104012443haulers
hausen9610383hause_n
hawsers13409483hawsers
hawses125113993hawse_s
housels105312133housels
housers104717813housers
houses96032273house_s
incuses93514853incuse_s
infusers11286143infusers
infuses102711873infuse_s
kaisers11369273kaisers
kashas133311903ka_shas
lapsers93911053lapsers
lapses85217693lapse_s
lasers64925703la_sers
lases54944763la_se_s
lasses64827593lasse_s
lauders84012893lauders
lauras63414333lau_ras
laurels746663laurels
louses66230283louse_s
manses84225513manse_s
marses84827113marse_s
masas75630413ma_s_as
masers84623453ma_sers
massas85116463ma_ssas
masses85028713masse_s
maulers94213303maulers
maumets11369693maumets
mauves113811553mauve_s
mousers95216443mousers
mouses85531423mouse_s
musers84719103_musers
muses75134303_muse_s
nabbers113710463nabbers
nabes75427093na_be_s
nachas114914193na_chas
naches114622413nache_s
nacres85614453nacre_s
nadas66320813na__das
naganas847983naganas
naggers93812653naggers
nailers73215893nailers
nailsets834553nailsets
nairas6312783na_iras
naives94914223naive_s
nakfas1334683na_kfas
nalas55528363na__las
naleds7469133na_leds
namers84517333na_mers
names74833363na_me_s
nanas55928633na__nas
nances83618643nance_s
napas75924353na__pas
napes74828463na_pe_s
napless93110283napless
nappas105511613na_ppas
nappers114214863nappers
nappes104515623nappe_s
nares55544153na_re_s
nasal56217593na_s_al
nasals63312463na_sals
nasial6413283na_sial
nates55238333na_te_s
natters73718063natters
natures7311963nature_s
naughts11447513naughts
nauseated1045233nauseated
navels95712693na_vels
naves87030383na_ve_s
navies95218623navie_s
naysay1234973nays_ay
naysays1344123naysays
neguses837933neguse_s
nesses64718323nesse_s
neumes83112623neume_s
neuters74212273neuters
nexuses1436743nexuse_s
niduses837013niduse_s
niseis63512023n_iseis
noises65021853noise_s
nonusers8268003nonusers
nonuses73313863nonuse_s
noosers74913923noosers
nooses65623643noose_s
noses55435643n_ose_s
nouveau1043953nouveau
nubias8310093n_ubias
nudes64723293n_ude_s
nukes95418123n_uke_s
nursers74311833nursers
nurses63919353nurse_s
oases55330983oa_se_s
onuses65616253onuse_s
opuses84012243opuse_s
ousels64815273_ousels
paisas84317493pais_as
parsecs11429923parsecs
parsers94118153parsers
parses85534703parse_s
paseos88015813pa_seos
pases75346503pa_se_s
pashas115117063pa_shas
passels93913023passels
passers94717753passers
passes86030473passe_s
pastas85422873pa_stas
paupers114311073paupers
pausal81511963paus_al
pause75021833pause__
paused95114963pause_d
pauser84415963pause_r
pluses83618073pluse_s
puses75532203_puse_s
raisers73617393raisers
raises64826543raise_s
rasers64526783ra_sers
rases55447213ra_se_s
reuses66025523reuse_s
rhuses94911793rhuse_s
rousers75220143rousers
rouses65436283rouse_s
ruses56136583_ruse_s
salsas65316133sals_as
sanseis73011603sanseis
sarsens7311393sarsens
sasses64124393sasse_s
saucers93712133saucers
sauces84919503sauce_s
saugers83914053saugers
saunas63915433sau_nas
saurels749303saurels
sautes63924913saute_s
seas45755273___seas
souses64229243souse_s
taluses7311213taluse_s
tarsias74013373tarsias
tassels74510853tassels
tasses64826763tasse_s
tassets75012773tassets
taupes8212673taupe_s
tautens7317843tautens
tawses94913193tawse_s
touses64229673touse_s
ureas55826013__ureas
uruses63616503uruse_s
users55817573__users
uses44931113__use_s
usneas638333__usneas
uveas84912283__uveas
valses94514613valse_s
varuses10310623varuse_s
vases84626263va_se_s
wadsets1136443wadsets
wamuses1237023wamuse_s
yaupers12337663yaupers
yautias1046333yautias

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.393454684.5
2DLD Change Limit1340272516.36021073.4
3Display Results2512510.0932698.9
 (SQL Overall)1786912516.84626101.5
 
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.