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

264 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
resumers103808(None) 
presumers1336371presumers
resumer9410111resumer_
resumes9313371resume_s
assumers1064962assumers
presumer1247582presumer_
presumes1239842presume_s
reamers94221082re_amers
rebukers14435682rebukers
reducers1147262reducers
refusers11499272refusers
refuters11449612refuters
relumes9612512relume_s
renumbers1344122renumbers
rescuers1037362rescuers
residers93311882residers
resters74130402res_ters
resume8313782resume__
resumed10310622resume_d
assumer965363assumer_
assumes967163assume_s
assurers866313assurers
besmears1234543bes_mears
censurers11256073censurers
cerumens1235763cerumens
consumers1337203consumers
costumers1374853costumers
creamers124111313cre_amers
defamers14258523defamers
defusers12487363defusers
deluders10156433deluders
denuders10165873denuders
desirers939263desirers
desugars1043373desugars
dreamers11369003dre_amers
dressers9359863dres_sers
eluders8409903_eluders
emmers104013223_e_mmers
ensurers8279373ensurers
epimers11109493_epimers
eskers105312223_es_kers
esters64627733_es_ters
exhumers2043263exhumers
festers104121393fes_ters
frescoers1454563frescoers
fumers113613383__fumers
gesturers1044283gesturers
heaumes1237423heaume_s
hegumens1444303hegumens
hemmers143310843he_mmers
inhumers1364823inhumers
insurers83710133insurers
isomers9310043_isomers
issuers746123issu_ers
jesters144118193jes_ters
kreuzers2132063kre_uzers
legumes1036633legume_s
measurers1144883measurers
mesomere1247193mesomere
mesomeres1347193mesomeres
metamers1249623metamers
misusers10348083misusers
nesters74422793nes_ters
nestlers8359223nestlers
neumes83112623ne_ume_s
neuters74212273ne_uters
perfumers1683713perfumers
perusers10328803perusers
pesters93827093pes_ters
preluders1234423preluders
prenumbers1642713prenumbers
presagers1236943presagers
presiders1248213presiders
pressers103215023pres_sers
presters103419003pres_ters
presume11310303presume__
presumed1337973presume_d
rammers113715043r_ammers
ransomers1146873ransomers
rasers64526783ras__ers
rashers104020913ras_hers
raspers94415923ras_pers
rasters74629023ras_ters
rasures7312013rasure_s
reachers133515723reachers
readers83823773re_aders
realters83614043realters
reamer84325213re_amer_
reapers93520453re_apers
rearers74323563re_arers
reasoners947113reasoners
reassumes1144463reassume_s
reavers108320743re_avers
rebaters103413943rebaters
rebuker13407843rebuker_
rebukes134210553rebuke_s
rebuses94915293rebuse_s
rebutters1195093rebutters
recamiers1345513recamiers
reciters102613113reciters
recovers133511123recovers
recurs83315803recu__rs
recuses94619463recuse_s
redders93615343re_dders
redeemers1244813redeemers
reducer1059003reducer_
reduces10513343reduce_s
reefers103312593re_efers
reekers113613143re_ekers
reelers73520273re_elers
reenters82915303reenters
refers93921083re__fers
refiners114713313refiners
reformers14246403reformers
refuels10399523refu_els
refugees12476403refugees
refuges115413373refuge_s
refunders1334973refunders
refuser104912783refuser_
refuses104918553refuse_s
refuter104312193refuter_
refutes104515733refute_s
regalers94311133regalers
regimens11469233regimens
regimes104514743regime_s
regulars936253regulars
rehammers1644503rehammers
reifiers11309843reifiers
reimmerse1343013reimmerse
reinsurers1043573reinsurers
reinters82614773reinters
reissuers954033reissuers
reivers105117083re_ivers
relaters83218153relaters
relaxers15298263relaxers
reliers75519213re_liers
relume8313273relume__
relumed1069813relume_d
remakers143811303remakers
remembers1544493remembers
removers13449223removers
renames92418053rename_s
renders83821673re_nders
renegers9248793renegers
renewers11238183renewers
renters74224813re_nters
rentiers83311763rentiers
renumber1244243renumber_
reoffers1434693reoffers
reorders9198833reorders
repapers1258833repapers
repiners103913433repiners
repliers103710163repliers
reposers102911603reposers
repowers13288533repowers
repulsers1144713repulsers
repumps1334403repum_ps
reputes94615963repute_s
requiems1943253requiems
requirers18165003requirers
requires17168703requires
requiters18176553requiters
resales74724903resale_s
rescores105415693rescores
rescuer939033rescuer_
rescues9312753rescue_s
reseeds84012333res_eeds
reseeks11348623res_eeks
resees63827483res__ees
resellers9299903resellers
resemblers1443413resemblers
reservers12138103reservers
resets65427613res__ets
resetters9129463resetters
resews94814173res__ews
reshapers1435493reshapers
reshes94124363res_he_s
reshoes102316033reshoe_s
reshowers15145473reshowers
resider84615803resider_
resides84523283reside_s
resigners1036863resigners
resiles74026543resile_s
resilvers12306503resilvers
resisters9310453resisters
resites74027793resite_s
resizes164216843resize_s
resmelt9411773res_melt
resmelts1046143res_melts
resojets1535343resojets
resolders10258013resolders
resoles73823653resole_s
resolvers12297833resolvers
resorters939693resorters
respires10311903respires
rester63832433res_ter_
restless82713163restless
restorers95110113restorers
restores85222993restores
restress82511773restress
resubmits1342793resubmits
results739833resu_lts
resuming11310083resuming
resummon1242233resummon
resummons1342303resummons
resurges9310123resurges
resurveys1542683resurveys
retakers123511133retakers
retempers1345023retempers
retimes95020173retime_s
retirers84311533retirers
retunes76918403retune_s
returners9376553returners
reuses66025523re_use_s
reutters8138573reutters
revampers1653443revampers
revelers113414133revelers
reverers113113153reverers
revers94529633re__vers
revilers114011693revilers
revisers113511933revisers
revivers14389633revivers
revokers15366753revokers
revues9813903revu_e_s
rhesuses1134893rhesuse_s
rhymers15365543r_hymers
rimers84522553r__imers
rimmers113812883r_immers
risers64624783ris__ers
riskers114011993ris_kers
risuses73210923risuse_s
roamers93713463r_oamers
roomers95416413r_oomers
rosters73727543ros_ters
rousers75220143r_ousers
rousters84315683rousters
routers74822873r_outers
ruers515019413r__u_ers
rulers64317093r__ulers
rumens83611813r__umens
rummers113513653r_ummers
rumors81110403r__umors
rushers103816103rus_hers
rustlers8339853rustlers
seamers94719433se_amers
securers1057153securers
seducers1145383seducers
seemers93814333se_emers
sesames9310743sesame_s
subers85722643__subers
suers55128483__su_ers
summers113616503__summers
supers84622403__supers
teemers95012903te_emers
termers95414503te_rmers
testers74124543tes_ters
treasurers1043203treasurers
usurers766363_usurers
venomers1336703venomers
vespers1239033ves_pers
westers105221963wes_ters
wresters112711733wres_ters
wrestlers12306103wrestlers
zesters163517293zes_ters

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622646.47022590.7
3Display Results2642640.1102400.0
 (SQL Overall)1786912646.98625578.4
 
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.