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

214 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
stranders1038993(None) 
standers93514301st_anders
strander97112061strander_
strangers104112161strangers
branders114313092_branders
estrangers11376102estrangers
sanders84025942s__anders
slanders94014012s_landers
solanders1036962solanders
squanders1934442squanders
standees93310142st_andees
stander84316162st_ander_
straddlers12203822straddlers
strafers11379912stra_fers
strainers9510382strainers
stranded102710812strande_d
strands83711952strand__s
stranger94715102stranger_
stranges94516762strange_s
stranglers11396822stranglers
strappers1346742strappers
strayers113510142stra_yers
striders94412122str_iders
stringers104210642stringers
traders84316952_tra_ders
abraders1137343abra_ders
arrangers1045813arrangers
attainders11112773attainders
attenders1045273attenders
banders104324563__banders
bilanders1235963bilanders
braiders114110573_braiders
brander103915823_brander_
branners104010923_branners
bystanders1642193byst_anders
colanders1238013colanders
corianders1344893corianders
curandera1242843curandera
curanderas1342273curanderas
curandero1242503curandero
curanderos1341953curanderos
danders93921183__danders
demanders13247573demanders
derangers1136703derangers
estranger10447843estranger_
estranges10359983estrange_s
expanders19125093expanders
frankers15348353_frankers
ganders93521703__ganders
germanders1444603germanders
glanders103811503_glanders
graders94716013_gra_ders
grandees103211283_grandees
grander93315873_grander_
grandeurs11335113_grandeurs
grangers103011973_grangers
granters93614143_granters
grinders103410423_grinders
handers114224333__handers
inlanders1036143inlanders
islanders1035283islanders
landers84026213__landers
malanders1237023malanders
marauders1244263marauders
meanders1168833_meanders
oleanders1035573oleanders
outlanders1144273outlanders
panders103423733__panders
paraders113113113para_ders
pomanders1436223pomanders
prancers123210333_prancers
raiders84615143__raiders
rangers83621043__rangers
rankers113217463__rankers
ranters73323643__ranters
renders83821673__renders
sander74828533s__ander_
sangers84421943s__angers
scanners10379703s_canners
scrannels1143513scrannels
scrapers125510533scra_pers
scrappers1545863scrappers
scrawlers1434753scrawlers
seconders1236953seconders
senders83022353s__enders
serenaders11204663serenaders
shaders115915553s_ha_ders
shredders1463713shredders
shrinkers16205383shrinkers
skankers11316483s_kankers
slander84015443s_lander_
solander948123solander_
sonders83820713s__onders
sorners73416873sor_n_ers
sounders93214113s_ounders
spaders104214473s_pa_ders
spankers14369863s_pankers
spanners103710773s_panners
spenders113211743s_penders
sprawlers1433903sprawlers
sprayers13367053spra_yers
spreaders1236503spreaders
springers12309983springers
sprinters11329363sprinters
squander1835533squander_
stabbers12268733st_abbers
stablers103611153st_ablers
stackers143413563st_ackers
stades74626243st_a_de_s
staffers14247083st_affers
stagers84116673st_a_gers
staggers10379843st_aggers
staider83912613st_aider_
stainers83212173st_ainers
stalkers12369853st_alkers
stammers123611523st_ammers
stampers124211603st_ampers
stances93715963st_ance_s
stanchers14206813st_anchers
standard1046253st_andard
standards1145203st_andards
standbys1443203st_andbys
standee83514513st_ande_e
stands75118053st_and__s
standups1143963st_andups
stanes64933403st_an_e_s
staplers103111203st_aplers
starers74522313st_a_rers
starkers123712393st_arkers
starters83714773st_arters
startlers9236743startlers
starvers11459643st_arvers
staters73922343st_a_ters
stayers103813633st_a_yers
steadiers1035083steadiers
stealers83412203stea_lers
steamers103410873stea_mers
stingers94012743st_ingers
stinkers123111133st_inkers
stinters83312753st_inters
stoners74817953st_on_ers
straddler11205113straddler_
straddles11216403straddles
strafer103912463stra_fer_
strafes104516003stra_fe_s
stragglers12305253stragglers
strainer8512223strainer_
straitens946233straitens
straiter8311783straiter_
strakes114218073stra_ke_s
strand74514823strand___
stranding1149653stranding
strange85416343strange__
strangely1345413strangely
strangered1245413strangered
strangest103210843strangest
strangler10369473strangler_
strangles103011553strangles
strangury1343203strangury
strapless1135793strapless
strapper1258093strapper_
strasses81311443strasse_s
strawier1137493strawier_
strayer104312503stra_yer_
streakers13218133streakers
streamers11228073streamers
streekers13195803streekers
strewers11409063str_ewers
strider84315723str_ider_
strides84520393str_ide_s
stridors9367323str_idors
strikers123611293str_ikers
stringer93812943stringer_
stripers103911593str_ipers
strippers1355773strippers
strivers113911843str_ivers
strokers123910903str_okers
strollers937543strollers
stronger9349693stronger_
stroppers1356713stroppers
stroyers11388923str_oyers
strudels934123str_udels
strummers1333693strummers
strutters955693strutters
stunners8277923st_unners
sunders84120053s__unders
surnamers1143803surnamers
surrenders1174153surrenders
tandems1037633_t_andems
tankers113416913_t_ankers
tanners74018393_t_anners
tenders83719723_t_enders
thankers15297833_thankers
thunders1236953_thunders
tinders84219173_t_inders
tracers94917843_tra_cers
trackers143512853_trackers
trader75218763_tra_der_
trades75724503_tra_de_s
trailers82912923_trailers
trainers83114643_trainers
trampers123210393_trampers
trances93919643_trance_s
transfers1238053_transfers
trappers123711043_trappers
trashers113013643_trashers
trawlers113310203_trawlers
treaders93311843_treaders
trundlers10215003_trundlers
twangers12226063_twangers
uitlanders1142833uitlanders
uplanders1234853uplanders
wanders114221333__wanders
zanders173015793__zanders

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412147.72019254.0
3Display Results2142140.0932301.1
 (SQL Overall)1786912148.23621696.3
 
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.