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

119 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
usurpers103373(None) 
usurers766361usur_ers
usurper934351usurper_
supers84622402_su_pers
suppers113314692_suppers
surfers103614132_surfers
surgers83517482_surgers
usurer638102usur_er_
usuries7510632usurie_s
usurped1035152usurpe_d
usurps8105072usurp__s
aspers86220313as__pers
assurers866303assur_ers
augurers9114803augur_ers
blurters10348363blurters
bumpers133912053_bumpers
burgers103918573_burgers
buriers94017193_buriers
burkers133716623_burkers
burlers94120273_burlers
burners94115673_burners
burrers93814493_burrers
carpers114521253_carpers
chirpers15358133chirpers
churners13316883churners
couriers103213163couriers
coursers104412293coursers
courters103015363courters
cruppers14317313cruppers
cuppers133712193_cuppers
curbers115514373_curbers
curers84923183_cur_ers
curlers94218063_curlers
cursers94317153_cursers
dorpers104113163_dorpers
dumpers123412663_dumpers
dupers94615603_du_pers
ensurers8279373ensur_ers
escapers12337413escapers
furlers104214223_furlers
gulpers10299003_gulpers
harpers124916203_harpers
humpers142713523_humpers
hurlers103714323_hurlers
hurters103413633_hurters
insurers83710133insur_ers
jumpers18399843_jumpers
lumpers113514483_lumpers
lurers64217493_lur_ers
lurkers113910083_lurkers
mourners1036913mourners
mumpers133311363_mumpers
murders103311363_murders
nursers74311833_nursers
paupers114311073pau_pers
plumpers14357293plumpers
pourers93513673pour_ers
pulpers114612283_pulpers
pumpers133113673_pumpers
purgers104714003_purgers
pursers93916093_pursers
sappers113518893_sappers
scarpers124712513scarpers
scrapers125510513_scrapers
scuppers1446533scuppers
sergers83815633_sergers
servers103214833_servers
shapers124016893_shapers
sharpers133810943sharpers
simpers113014113_simpers
sippers113117743_sippers
slopers94213093_slopers
snipers93311763_snipers
soapers93715923_soapers
sorners73416863_sorners
sorters74221113_sorters
spurners10288493spurners
spurrers10338453spurrers
spurters103311693spurters
stopers94217363_stopers
stripers103911583_stripers
stumpers12318313stumpers
subers85722643_su_bers
suckers133717623_suckers
sudsers83310413_sudsers
suers55128483_su__ers
suffers133113543_suffers
suiters73618873_suiters
sulkers113613343_sulkers
summers113616503_summers
sumpters1238023_sumpters
sunders84120053_sunders
super74924483_su_per_
superb104410993_su_perb
supes75628303_su_pe_s
supper104115433_supper_
surer54833093_sur_er_
surfer93515883_surfer_
surger74320093_surger_
surgery11319203_surgery
surges73924593_surge_s
surpass938283_surpass
surplus936793_surplus
surreys10489433_surreys
surveys13357573_surveys
sutlers73116973_sutlers
thumpers15365713thumpers
tourers73512733tour_ers
turners73912893_turners
uppers102912283__uppers
upsurges11144803upsurge_s
urgers73313623__urgers
users55817573us___ers
ushers94415533us__hers
usurious845263usurious
usurp7106903usurp___
usurping1134163usurping
warpers123413583_warpers
yaupers12337663yau_pers

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.1531167915.0
2DLD Change Limit1461621198.61016975.8
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.80920285.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.