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

201 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
registers103889(None) 
register939551register_
resisters9310451resisters
demisters1249202demisters
enregisters1252072enregisters
heisters113413132he_isters
keisters123212042ke_isters
leisters83312822le_isters
magisters1235802magisters
meisters103313842me_isters
reciters102613112reci_ters
refilters1236102refilters
regisseurs1141442regisseurs
registered1245292registered
registrars1152392registrars
registry1244632regist_ry
reinters82614772re_inters
remasters11310582remasters
remitters11328402remitters
reregisters1242852reregisters
resister8311652resister_
resistors947992resistors
resters74130402re__sters
revisers113511932revis_ers
roisters83615562r_oisters
aegises8311373aegis_e_s
assisters936353assisters
banisters11189473banisters
begetters12135043begetters
beginners1283613beginners
bisters93922613__bisters
blisters104015083_blisters
canisters112310203canisters
cloisters1137443cloisters
deemsters1285023deemsters
degassers11354833degassers
delusters1035983delusters
demister11310223demister_
dempsters1435273dempsters
depicters1435823depicters
detesters10298303detesters
devisers12339863devis_ers
digesters11257883digesters
dragsters1134333drag_sters
easters75125683_e_asters
egises7312493_egis_e_s
emitters10349643_emitters
enlisters937113enlisters
enregister1152533enregister_
epistlers1154113_epistlers
esters64627733_e__sters
feasters11511563fe_asters
festers104121393fe__sters
filisters1237003filisters
freighters1764123freighters
gagsters10317083gag_sters
ganisters10248313ganisters
gasters85624303__gasters
glisters93912603_glisters
gristers94013413_gristers
heister103613623he_ister_
hemipters1645683hemipters
hoisters113513493_hoisters
insisters997653insisters
jesters144118193je__sters
keesters12319593ke_esters
keister113011573ke_ister_
keysters15326333ke_ysters
klisters123910483_klisters
lamisters1157123lamisters
legists899593legist__s
leister73212753le_ister_
listers74026533__listers
magister1136283magister_
megastars1243653megastars
meister93114163me_ister_
meristems1343553meristems
ministers1139623ministers
misregisters1551773misregisters
misters93927513__misters
negaters9349783neg_aters
nesters74422793ne__sters
pensters103012123pe_nsters
peripters1368123peripters
persisters1246283persisters
pesters93827093pe__sters
plaisters1137813plaisters
preregisters1552233preregisters
presters103419003pre__sters
raisers73617393r_ais_ers
rasters74629023r__asters
ravishers1564783ravishers
realisers9248323realis_ers
realters83614043re_alters
rebaters103413943re_baters
rebutters1195093rebutters
recanters112310483recanters
reciter94117263reci_ter_
recites93524583reci_te_s
reenters82915313re_enters
refastens1244753refastens
refilter1137153refilter_
refiners114713313refi_ners
refusers11499273refus_ers
refuters11449613re_futers
regainers10237383regainers
regalers94311133reg_alers
regathers1336353regathers
regimens11469233regi_mens
regimes104514743regi_me_s
regisseur1041543regisseur
registering1346393registering
registrar1042783registrar
registries1146503registries
regives115014213regi_ve_s
regrates92618403regrate_s
regretters1144093regretters
reheaters122010273reheaters
reifiers11309843re_ifiers
reinter73116843re_inter_
reissuers954033reissuers
reivers105117083re_i_vers
rejecters18257543rejecters
rejiggers1843013rejiggers
relaters83218153re_laters
reletters9138783reletters
reliers75519213reli__ers
relievers12387063relievers
relishes11311953relishe_s
relisted9312623reliste_d
relists73817053relist__s
remaster10311473remaster_
reminders12308653reminders
remises93423483remis_e_s
remitter102810323remitter_
remittors11256283remittors
remoistens12164523remoistens
renters74224823re__nters
repeaters112811993repeaters
repenters112511553repenters
repiners103913433repi_ners
replasters1245533replasters
reporters1139173reporters
reposers102911603repos_ers
reprinters1295793reprinters
requesters1944323requesters
requiters18176553requiters
reregister1143693reregister_
rerises73525883reris_e_s
resetters9129463resetters
residers93311883resi_ders
resigners1036863resigners
resilvers12306503resilvers
resisted9312693resiste_d
resistless1043173resistless
resistor847673resistor_
resists74414923resist__s
resites74027793resi_te_s
resorters939693resorters
rester63832433re__ster_
retastes82212903retaste_s
retirers84311533reti_rers
retorters938773retorters
reuniters936423reuniters
reutters8138573re_utters
reverters122710433reverters
reviewers1543893reviewers
revilers114011693revi_lers
reviser104114663revis_er_
revises104220533revis_e_s
revisors11379063revis_ors
revivers14389633revi_vers
revolters12297483revolters
rewinders13246503rewinders
rewriters1236343rewriters
righters122610713rig_hters
rimesters1137493rimesters
rioters73615523r__ioters
risers64624783r__is_ers
riskers114011993r__iskers
ritters74020623r__itters
roadsters1035103roadsters
roasters83615933r_oasters
roister73516203r_oister_
roosters83514673r_oosters
rosters73727553r__osters
rousters84315683r_ousters
roysters113610533r_oysters
seamsters1136333seamsters
seisers73816393se_is_ers
semesters1139123semesters
sisters73721593__sisters
teamsters1135973teamsters
testers74124543te__sters
twisters11268173_twisters
waisters113811523_waisters
websters1335803we_bsters
weighters1644673weighters
westers105221963we__sters
wresters112711733wre__sters
zesters163517293ze__sters

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 Filter1786911486410.436409841.7
2DLD Change Limit1486412017.03021143.8
3Display Results2012010.0932161.3
 (SQL Overall)1786912017.55923639.5
 
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.