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

195 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
reannex143473(None) 
annex12310882__annex
coannex1635512coannex
reannexed1743062reannexed
reannexes1643162reannexes
reindex1536092reindex
remanned11319352remanned
rennet64624852re_nnet
annexe1337813__annexe
banned94721343_banned
banner84421503_banner
bannet84925333_bannet
beaned95621473bea_ned
beanie83618593beanie_
beanies93821093beanies
benne76521123be_nne_
bennes86019013be_nnes
bennet84823363be_nnet
branned104311693branned
branner94212373branner
canned95022063_canned
cannel84216403_cannel
canner84625983_canner
channel123910483channel
deaned84620453dea_ned
denned84215633de_nned
earned74818333_earned
earner63617223_earner
fanned104117473_fanned
fanner94218183_fanner
fennec11326913fe_nnec
fennel9429473fe_nnel
flannel1035423flannel
gannet74321853_gannet
jeaned143813463jea_ned
jennet134714953je_nnet
joannes1436243joannes
kenned114411273ke_nned
kennel10369223ke_nnel
lanner64920603_lanner
leaned73422543lea_ned
leaner64022193lea_ner
leanness837373leanness
learned8329303learned
learner7319383learner
manned94418643_manned
manner84020513_manner
meander1049973meander
meaner84617843mea_ner
meanie83718393meanie_
meanies93620743meanies
meanness1037183meanness
panne76623653_panne_
panned94123433_panned
panner84224763_panner
pannes85522853_pannes
penne75423853pe_nne_
penned94217613pe_nned
penner84616663pe_nner
planned103810153planned
planner93511623planner
rained75024603r_ained
rance75028513r_ance_
rances84625443r_ances
ranee55438103r_a_nee
ranees64623963r_anees
range64728413r_ange_
ranged84824313r_anged
ranger73925523r_anger
ranges73826923r_anges
ranked114620743r_anked
ranker105021903r_anker
ranted74324703r_anted
ranter63826823r_anter
reached134619083reached
reacher123718293reacher
reaches123423203reaches
reacted103015713reacted
readded103310733readded
reader73628293rea_der
readied93316623readied
readier83117423readier
readies83324713readies
reaffix2042323reaffix
reagent8716603reagent
realer63528593rea_ler
reales64934123rea_les
realness8410443realness
realter73716313realter
reamed94326123rea_med
reamer84325213rea_mer
reannexing1843153reannexing
reaped94122453rea_ped
reaper84223143rea_per
reared75930013rea_red
rearer64928913rea_rer
rearmed103912823rearmed
reasoned9410733reasoned
reasoner849343reasoner
reave84528023rea_ve_
reaved104523923rea_ved
reaver94524733rea_ver
reaves94127573rea_ves
recane83022873recane_
recaned102817203recaned
recanes93222263recanes
recanted112513513recanted
recanter101913153recanter
rechannel1444323rechannel
reconned113610653reconned
redone74820053redone_
redonned10297103redonned
reearned948883reearned
reenter73217793reenter
refine95225693refine_
refined114720003refined
refiner105316913refiner
refines105426343refines
reflex16359513re_flex
regained102111243regained
regainer9249353regainer
rehanged1357833rehanged
reigned949213reigned
reined74425523re_ined
reinked1239793reinked
reinter73116843reinter
relanded102410463relanded
reline65434353reline_
relined85321933relined
relines75331323relines
remained112412893remained
remanded123011323remanded
remanent10311703remanent
remex146315793re__mex
rename82718813rename_
renamed103114523renamed
renames92418053renames
rended84524103re_nded
render74024143re_nder
renew83917513re__new
rennets75212633re_nnets
rennin63914033re_nnin
rente54733783re_nte_
rented74426593re_nted
renter64527413re_nter
rentes65431193re_ntes
repanel939963repanel
repine85627813repine_
repined104918773repined
repiner94816903repiner
repines94927383repines
repinned1157473repinned
replanned1235163replanned
resined84522653resined
retained93016093retained
retainer82913813retainer
retene69224273retene_
retenes76324623retenes
retine66237333retine_
retines75134673retines
retune69121953retune_
retuned86613973retuned
retunes76918403retunes
rexine134719443rexine_
rexines144719153rexines
rezone153814783rezone_
rezoned173611163rezoned
rezones163213943rezones
ronnel63310883r_onnel
runnel63510663r_unnel
runner63814463r_unner
scanned104110893scanned
scanner94411813scanner
seance83716693seance_
seances93015343seances
sennet64224143se_nnet
spandex1735833spandex
spanned104111223spanned
spanner94312563spanner
swanned11358173swanned
tanned75219953_tanned
tanner63722283_tanner
tenner64117103te_nner
trepanned1243913trepanned
trepanner1143523trepanner
vanned104614483_vanned
vanner94215843_vanner
wanned104318013_wanned
wanner94019623_wanner
weaned103816153wea_ned
weaner93816773wea_ner
yeaned103813903yea_ned
yearned11327373yearned
yearner10336873yearner
yenned10409383ye_nned

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271956.34321129.9
3Display Results1951950.0603250.0
 (SQL Overall)1786911956.80926243.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.