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

148 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
endorses95997(None) 
endorse879201endorse_
endorsed1057191endorsed
endorsee968601endorsee
endorsees1045501endorsees
endorser966731endorser
endorsers1046121endorsers
indorses968061indorses
encores9315212encor_es
endorsor943722endorsor
endorsors1044332endorsors
endures83314602endur_es
enforces13208012enforces
engorges1045752engorges
indorse8108192indorse_
indorsed1066122indorsed
indorsee977442indorsee
indorsees1094442indorsees
indorser985712indorser
indorsers1075382indorsers
unhorses1138452unhorses
adores74420713_ador_es
aldoses8311203aldo_ses
bandores11311603bandor_es
condores113315633condor_es
corses84433463__corses
dories75232363__dories
dorsel75315503__dorsel
dorsels84412573__dorsels
dorser74819173__dorser
dorsers83516293__dorsers
doses65938503__do_ses
dosses76126273__dosses
douses74928933__douses
dowses105718303__dowses
ecdyses1333413ecd_yses
eddoes8199143eddo__es
eldress835003eld_ress
embosses1235963embosses
encases93116053en_cases
enchases13310273enchases
encloses10911053encloses
encodes10310643enco_des
encore8314773encor_e_
encored10412103encor_ed
endashes12217453endashes
enders74324053ender__s
endgames1245423endgames
endites83717063end_ites
endives113710693end_ives
endless839833endles_s
endnotes945943endnotes
endocasts1244763endocasts
endocrines1365523endocrines
endogen938613endo_gen
endogens1047953endogens
endopods1245673endopods
endorsing1147303endorsing
endorsive1344213endorsive
endosmos1144353endosmos
endosmoses1354193endosmoses
endosomes1246663endosomes
endostea944953endostea
endowed1248173endo_wed
endower1138483endo_wer
endowers1238233endowers
endows104610423endo__ws
endrins8312163end_rins
endues73813903end__ues
endure74014143endur_e_
endured93611213endur_ed
endurer83210363endur_er
endurers9317953endurers
enduros8298153endur_os
endwise1136463endwise_
enforce12237423enforce_
enforced14216743enforced
enforcer13246503enforcer
enforcers14215213enforcers
engorge945543engorge_
engorged1134553engorged
engross837123engros_s
engrosses1045473engrosses
enlarges946073enlarges
ennobles1045113ennobles
enolases8411003enolases
enosis63816423en_o_sis
enosises8311003enosises
enrobes92211113enro_bes
ensorcel1054693ensorcel
ensorcels1143423ensorcels
ensures73315903ensur_es
entases72816273en_tases
enthuses1138253enthuses
entires71517783entir_es
entrees71813773en_trees
entries71523163en_tries
enures63919713en_ur_es
enureses838113enureses
eposes84418783e_po_ses
eroses65327053e_ro_ses
erses55826803e___rses
espouses1037303espouses
ethoses10311753etho_ses
exoduses1644803exoduses
exposes1639963expo_ses
gendarmes1343923gendarmes
genoises939253gen_oises
gnoses76515163gn_o_ses
gorses74723293__gorses
henhouses1546173henhouses
hidroses1237903hidroses
horses94729343__horses
incorpses1345173incorpses
indoles83716363indo_les
indorsor953203indorsor
indorsors1043673indorsors
inverses112410983inverses
necroses10310563necroses
neuroses8310153neuroses
noises65021853_n_oises
nooses65623643_n_ooses
noses55435643_n_o_ses
nouses64627163_n_ouses
nurses63919353_n_urses
pandores11312453pandor_es
pentoses10312893pento_ses
redhorses1345653redhorses
remorses10311993remorses
seahorses1246163seahorses
senhores112810993senhor_es
senores73218113sen_or_es
snores64324313sn_or_es
torses64727953__torses
undersea9149883undersea
underseas1087803underseas
underset91417133underset
undersets10129323undersets
underuses1039903underuses
undoes73917403undo__es
undress838893und_ress
unhorse1038583unhorse_
unhorsed1238833unhorsed
unhouses1138703unhouses
unlooses8127293unlooses
vendeuses1343393vendeuses
vendors113510223vendor__s
worses95522953__worses

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.1731032896.0
2DLD Change Limit1461621487.17020385.2
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.40624127.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.