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

267 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
righters12261071(None) 
fighters15269401fighters
lighters123111391lighters
righter113212381righter_
sighters122510601sighters
blighters1555742blighters
brightens1565372brightens
brighter1476662brighter_
fighter143010772fighter_
freighters1764122freighters
frightens1655392frightens
lightens122510002lightens
lighter113113442lighter_
plighters1545532plighters
riggers93613842rig_gers
righted122912142righte_d
righteous1345072righteous
rightest12149582rightest
righties12711572righties
rightness13117352rightness
rights104019332right__s
rioters73615512ri_oters
ritters74020622ri_tters
riveters11228162riveters
sighers113712182sigh_ers
sighter113412112sighter_
slighters1346712slighters
tightens12297952tightens
tighter112910692tighter_
weighters1644672weighters
bighted142810923bighte_d
bights124417963bight__s
bisters93922613bi_sters
biters83925243bi__ters
bitters94920363bi_tters
blighter1466853blighter_
brighten1466243brighte_n
brighteners1752863brighteners
brightest1545663brightest
brightness1644573brightness
brights133710233bright__s
ciphers14379993ciph_ers
citers85022983ci__ters
cithers124315773cith_ers
critters103511323cri_tters
daughters1443993daughters
delighters1544363delighters
diasters92913183diasters
diesters92513603diesters
dieters83216433di_eters
diethers1257453diethers
digesters11257883digesters
diggers104413393dig_gers
dighted132511493dighte_d
dights114016963dight__s
dilaters92513063dilaters
diluters9288113diluters
dimeters11411093dimeters
diopters1137693diopters
dithers114016153dith_ers
dragsters1134323dragsters
drifters12417913dri_fters
eighteen1245763eighteen
eighteens1344883eighteens
eighths14388293eight_hs
eighties12710803eighties
eights103618983eight__s
eightvos1543743eightvos
fagoters1234863fagoters
fibsters13126413fibsters
fidgeters1443623fidgeters
figeaters1345753figeaters
fights133816553fight__s
figurers12254873figurers
filters103816553fi_lters
fishers134714723fish_ers
fitters104517753fi_tters
flichters1774173flichters
freighter1655023freighter_
frigates12310933frigate_s
frighted1657173frighte_d
frighten1566443frighte_n
frights14339623fright__s
fritters113810783fri_tters
gagsters10317083gagsters
gaters74728643__gaters
gigglers11297403gigglers
grifters12389233gri_fters
gristers94013403gri_sters
gritters94210633gri_tters
heightens1644713heightens
higglers13297233higglers
higher134610893high_er_
highness1536053highness
highted152710163highte_d
highths13358003hight_hs
hightops1745043hightops
hights133716893hight__s
hinters103719583hi_nters
hipsters13268793hipsters
hitters104717593hi_tters
igniters9126233_igniters
infighters1743323infighters
inters64328053_i_nters
jiggers164010183jig_gers
jilters144211963ji_lters
jitters144314473ji_tters
kiesters123310153kiesters
kilters113813603ki_lters
kiters105218593ki__ters
laughters1344593laughters
lifters104313783li_fters
ligates82318383ligate_s
ligers75022043lig__ers
lighted122913503lighte_d
lighten112811523lighte_n
lighteners1444983lighteners
lightered1446283lightered
lightest121410353lightest
lightless1386073lightless
lightness13107433lightness
lights104519913light__s
limiters10249333limiters
linters73822633li_nters
listers74026533li_sters
liters65429883li__ters
litters73422573li_tters
mightier1436383mightier_
mights123516253might__s
milters93619093mi_lters
minsters103813923minsters
minters93822473mi_nters
misters93927513mi_sters
miters84328783mi__ters
mithers123516733mith_ers
negaters9349783negaters
niggers93111323nig_gers
nigglers10307253nigglers
nigher103612753nigh_er_
nighness1236103nighness
nighties121011383nighties
nightjars2043343nightjars
nightless1386073nightless
nights104117723night__s
niters64624213ni__ters
orienters937613orienters
piasters102912813piasters
pishers123815753pish_ers
plighter1476623plighter_
printers103214903pri_nters
rafters103715633r_afters
ranters73323643r_anters
rashers104020913rash_ers
rasters74629023r_asters
raters63936583r__aters
ratters74422473r_atters
realters83614043realters
rebaters103413943rebaters
reciters102613113reciters
reenters82915303reenters
refuters11449613refuters
regalers94311133regalers
regathers1336353regathers
registers1038893registers
reinters82614773reinters
relaters83218153relaters
renters74224813r_enters
resters74130403r_esters
retightens1453683retightens
reutters8138573reutters
ribbers113913183ri_bbers
ribiers9319753ri_biers
ricers84120993ri__cers
richens12349733rich_ens
richer114015043rich_er_
riches115022083rich_e_s
richness1337433richness
ridders93612493ri_dders
riddlers10269103riddlers
riders74123903ri__ders
rievers104311453ri_evers
rifflers14336443rifflers
riflers103512193ri_flers
rigger85616713rig_ger_
right94430503right___
rightful1544233rightful
righting132610853righting
rightism14156963rightism
rightisms15105623rightisms
rightist12159143rightist
rightists13126053rightists
rightly14389043right_ly
rightmost1544053rightmost
righto104111093right__o
rightward1743473rightward
righty135011833right__y
rigors72813713rig__ors
rigours8207003rig_ours
rimers84522553ri__mers
rimesters1137483rimesters
rimmers113812883ri_mmers
ringers83922953ri_ngers
rinsers73815743ri_nsers
rioter64817283ri_oter_
ripeners1036833ripeners
rippers114115033ri_ppers
ripplers12337113ripplers
risers64624783ri__sers
riskers114011993ri_skers
rites54442553ri__te_s
ritter63822423ri_tter_
rivers94626543ri__vers
riveter10208753riveter_
roasters83615933roasters
rogers74517913rog__ers
roisters83615553roisters
roosters83514663roosters
rooters74522933r_ooters
rosters73727543r_osters
rotters74421393r_otters
roughers12329183rough_ers
rousters84315683rousters
routers74822873r_outers
roysters113610533roysters
ruggers94612313rug_gers
rushers103816103rush_ers
sifters103714793si_fters
sigher103813703sigh_er_
sighless1276553sighless
sighted123111523sighte_d
sightless1385923sightless
sights103818013sight__s
sightseers1452543sightseers
sightsees1344543sightsees
signers84714443sig_ners
sinters74024083si_nters
sisters73721593si_sters
sitters74221553si_tters
slighter1257823slighter_
tigers75616513tig__ers
tighten11288973tighte_n
tighteners1444043tighteners
tightest12148363tightest
tightness1386603tightness
tights104015853tight__s
tilters73315953ti_lters
tinters74221113ti_nters
tipsters10278513tipsters
titers64526413ti__ters
tithers104216733tith_ers
titters74219623ti_tters
triggers10257843trig_gers
trimeters1139213trimeters
visiters1137413visiters
weighers15135673weigh_ers
weighter1535603weighter_
wigglers13257213wigglers
wights133315783wight__s
winters103720483wi_nters
wishers133215213wish_ers
withers134417753with_ers
wrigglers14273713wrigglers
wrights14318993wright__s
writers105513493wri__ters
writhers14398983writh_ers
yachters1633883yachters
zithers193911973zith_ers

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.1701051123.5
2DLD Change Limit1461622677.31319986.6
3Display Results2672670.1232170.7
 (SQL Overall)1786912677.60623493.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.