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

149 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
usurper93435(None) 
usurer638101usur_er
usurped1035151usurped
usurpers1033741usurpers
super74924482_su_per
supper104115432_supper
surer54833102_sur_er
surfer93515882_surfer
surger74320092_surger
usurers766362usur_ers
usuries7510632usuries
usurp7106902usurp__
usurps8105072usurp_s
absurder11134363absurder
asper75520433as__per
assurer767793assur_er
asunder856233asunder
augurer8136343augur_er
blurter9419833blurter
bumper123714343_bumper
burger94020793_burger
burier84324653_burier
burker125221173_burker
burler84723833_burler
burner83819203_burner
burped116215503_burped
burrer83718473_burrer
carper104923633_carper
chirper14359963chirper
churner12298343churner
courier93617893courier
courser94114803courser
courter94516483courter
crupper13338563crupper
cupper124313863_cupper
curber104517053_curber
curer75030753_cur_er
curler85221323_curler
curser84721473_curser
curter85320083_curter
dorper94314573_dorper
dourer74215273dour_er
dumper114615213_dumper
duper85519003_du_per
ensurer73011903ensur_er
escaper11368843escaper
furler93616403_furler
gulper93410213_gulper
harper115018403_harper
humper134115883_humper
hurler94717223_hurler
hurter93915853_hurter
insurer73312803insur_er
jumper173612373_jumper
lumper103816653_lumper
lurer54625313_lur_er
lurker103613293_lurker
mourner938093mourner
mumper123513523_mumper
murder93613783_murder
murker123715243_murker
nurser64314503_nurser
pauper103511943pau_per
plumper13318783plumper
pourer84516043pour_er
pulper103513273_pulper
pumper124415553_pumper
purer75127903_pur_er
purger94717233_purger
purpler11289273_purpler
purser85020473_purser
sapper103822353_sapper
scarper114814823scarper
scraper114513423_scraper
scupper1367423scupper
serer55935513_ser_er
serger73819743_serger
server94917713_server
shaper114119933_shaper
sharper124312703sharper
simper103616293_simper
sipper103920993_sipper
sloper84615913_sloper
slurped10368753slurped
sniper84413643_sniper
soaper84517873_soaper
sorer56236593_sor_er
sorner64720393_sorner
sorter64425093_sorter
sourer63620213sour_er
sprier84119063_sprier
spryer11418533_spryer
spurner9269653spurner
spurrer93710223spurrer
spurter94013003spurter
stoper84320103_stoper
striper94514793_striper
stumper113610093stumper
suaver93014233_suaver
suber74924503_su_ber
subpar1048673_subpar
sucker124120663_sucker
sudser73511283_sudser
suer45334033_su__er
suffer124314513_suffer
suiter64121813_suiter
sulker104015923_sulker
summer104017713_summer
sumpter1138873_sumpter
sunder74019833_sunder
supe65932763_su_pe_
superb104410993_su_perb
supers84622403_su_pers
supes75628303_su_pes
supped114415703_supped
suppers113314703_suppers
suppler1148443_suppler
sure45447413_sur_e_
surfed103814463_surfed
surfers103614133_surfers
surfier102613543_surfier
surge65027693_surge_
surged84118883_surged
surgers83517483_surgers
surgery11319213_surgery
surges73924593_surges
surlier72915443_surlier
surrey94414583_surrey
survey124111673_survey
sutler63718393_sutler
thumper14356953thumper
tourer64115073tour_er
turner63914613_turner
unriper9188283unriper
unsure62815413unsur_e_
untruer737113untruer
unurged939143unurged
upper93714263__upper
upsurge10134333upsurge_
upsurged12124043upsurged
upsurges11144803upsurges
urger64116473__urger
urped84615283__urped
user45023003us___er
usher84517763us__her
usurping1134163usurping
usury887623usur__y
warper114015583_warper
yauper11368543yau_per

Search took 8 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.406440125.6
2DLD Change Limit1340271496.54620474.6
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.99825534.6
 
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.