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

222 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
surpass93828(None) 
outpass939712outpass
sourpuss1042312sourpuss
strass67117222str_ass
subbass1138032subbass
surahs94515542sur_ahs
suras55336332sur_a_s
surbase939792surbase
surbases10310002surbases
surpassed1244132surpassed
surpasser1143862surpasser
surpasses1145532surpasses
surplus936792surplus
surras65919532surra_s
auras55932563aur_a_s
brass75428023_br_ass
burans85019303bur_ans
buras74736303bur_a_s
bureaus979293bureaus
burgess10409343burgess
burials93612083burials
burkas124513803burka_s
burlaps1156253burlaps
burps94220173burp__s
burqas174410903burqa_s
bursars94510893bursars
bursas85318273bursa_s
bypass1345043_bypass
carcass11310513carcass
carpals113414633carpals
compass13379563compass
crass76328043_cr_ass
cuirass934973cuirass
cuppas12458593cuppa_s
currans9310613currans
curtals93111623curtals
cutlass938013cutlass
duras65727733dur_a_s
durbars1077973durbars
duress74712063dur_ess
durians839573durians
durmast1037623durmast
durmasts1144093durmasts
durras74713373durra_s
frass85321123_fr_ass
furans94515953fur_ans
furless103210143furless
grass66125203_gr_ass
harass9313943har_ass
hardass1139753hardass
huppahs1743333huppahs
hurrahs13336773hurrahs
hurrays13386153hurrays
jurats134213203jur_ats
kurbash1643803kurbash
kurgans12145653kurgans
kurtas10349883kurta_s
lurdans837073lurdans
morass84614503mor_ass
murals84016763mur_als
muras75329583mur_a_s
murras84916013murra_s
overpass13258653overpass
pass65239953___pass
pupas95219283pu_pa_s
purdahs13285483purdahs
purdas92612263purda_s
purples112712833purples
purpose1137383purpose
purposes1237823purposes
quass144413763qu__ass
repass84114703_repass
salpas85116923salpa_s
sampans112411003sampans
sarans64224433sar_ans
sarapes94617753sarapes
sarcasm1136693sarcasm
sarcasms1244983sarcasms
sardars83112903sardars
sargasso942253sargasso
sarsars73512143sarsars
sass45035623s___ass
saurians837763saurians
scrags95713803scr_ags
scrams105216623scr_ams
scrapes116217663scrapes
scraps106017243scr_aps
screaks13469363screaks
screams114810623screams
secpars1138413secpars
sepals85217373s_epals
seracs84418573ser_acs
serais64326133ser_ais
serapes95218103serapes
seraphs12408093seraphs
serdabs1035323serdabs
serials73919743serials
serosas7312663serosas
servals103410743servals
sherpas1238093sherpa_s
sirdars8228213sirdars
sirrahs10377303sirrahs
sirras63814863sirra_s
slurps84410003slurp__s
smartass1044273smartass
soras55041013sor_a_s
sourness839543sourness
spaes76029973s__paes
spams94922193s__pams
spans74528733s__pans
spars75431543s__pars
spas67036723s__pa_s
spasm94514173s__pasm
spasms10418973s__pasms
spats75031383s__pats
spays105520513s__pays
sprags95715823spr_ags
sprats85819933spr_ats
sprays115913643spr_ays
spreads1039763spreads
straps87721783str_aps
straws98718673str_aws
strays96417933str_ays
streaks114411273streaks
streams94713373streams
stress66616673str_ess
stupas83910883stupa_s
subahs114512383su_bahs
subas74724073su_ba_s
subbase1139323subbase
subbases1239063subbases
subclass1246623subclass
submiss1138083submiss
subpar1048663subpa_r
subpart11311123subpart
subparts1246903subparts
subphase1555603subphase
subphases1645763subphases
subtask1335713subtask
subtasks1444493subtasks
subways1536163subways
succahs1435323succahs
success1146403success
succuss1134993succuss
sucrase9310343sucrase
sucrases10310253sucrases
sugars7312423su_gars
sukkahs1382703sukkahs
suldans8299723suldans
sulfas9311563sulfa_s
sulphas1236243sulphas
sultans72411833sultans
sumacs105512103su_macs
sumless92611123sumless
summas104313163summa_s
sumps95023433sump__s
sundaes8313093sundaes
sunfast1038503sunfast
sunglass945093sunglass
sunless73013693sunless
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunrays1037083sunrays
suntans72111733suntans
supers84622403su_pers
supes75628303su_p_es
suppers113314703suppers
supples11511283supples
suppose1137973suppose
supposes1238203supposes
suppress1236443suppress
supra73614253supra__
sups64834433su_p__s
sura45740293sur_a__
surah86823253sur_a_h
sural55931263sur_a_l
surbased1136613surbased
surcease1086883surcease
surceases1157473surceases
surcoats1047943surcoats
surds65624663sur__ds
sureness8912903sureness
surest65026763sur_est
surface1238653surface
surfaces1338673surfaces
surfers103614133surfers
surfs85022543sur__fs
surgers83517483surgers
surges73924593sur_ges
surimis938843surimis
surmise9311083surmise
surmises10310643surmises
surname937603surname
surnames1037273surnames
surpassers1243083surpassers
surpassing1343833surpassing
surpluses1155433surpluses
surprise1037673surprise
surprises1137433surprises
surra55521343surra__
surreys10489443surreys
surtax1337843surta_x
surtaxes1536513surtaxes
surveys13357573surveys
suss45229303su___ss
sutras64818593sutra_s
suttas63813793sutta_s
tarpans92513533tarpans
trass56226473_tr_ass
turbans939563turbans
turps74918733turp__s
upas68322383_u_pa_s
upases84112903_u_pases
urase54624693_ur_ase
urases63723563_ur_ases
ureas55826013_urea_s
urease64516993_urease
ureases74416723_ureases
urials64415193_urials
urps66920483_urp__s
usurpers1033743usurpers
usurps8105073usurp__s

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.403443402.0
2DLD Change Limit1340272225.98622390.1
3Display Results2222220.0762921.1
 (SQL Overall)1786912226.46527639.8
 
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.