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

197 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
torpedo103505(None) 
torpedos1143931torpedos
foredo10510822for_edo
teredo7310782ter_edo
toledo7419992to_ledo
toped85631312to_ped_
topped114617722topped_
torero6313202tor_ero
tornado845672tornado
torpedoed1342582torpedoed
torpedoes1243942torpedoes
torpid9310912torpid_
torpids1037372torpids
bopped134413403bopped_
bored85034303bor_ed_
boredom1236943bor_edom
borked135117293borked_
burped116215503burped_
carped115923763carped_
comedo11359603co_medo
comped135919873comped_
cooped114821603cooped_
coped105036843co_ped_
copped135221253copped_
corded105923353corded_
cored85044223cor_ed_
corked135020783corked_
corned95224523corned_
couped115019313couped_
credo84815573_cr_edo
doped95326713do_ped_
dorado838813dor_ado
dorper94314573dorpe_r
dorpers104113173dorpers
fopped144012673fopped_
forced126316523forced_
forded115020393forded_
fordo97218653for__do
forego1038903for_ego
forged115519323forged_
forked145217143forked_
formed125021173formed_
gored75227083gor_ed_
gorged95016983gorged_
gormed105013833gormed_
groped107515053groped_
harped124418403harped_
hooped125518183hooped_
hoped115628183ho_ped_
hopped144318113hopped_
horded115420483horded_
horned105718703horned_
horsed105321083horsed_
looped95217173looped_
loped85128333lo_ped_
lopped114218623lopped_
lorded84916733lorded_
louped95316383louped_
moped105424733mo_ped_
mopeds11499663mo_peds
mopped134114323mopped_
morphed1537133morphed_
morpho13158443morp_ho
normed95014543normed_
oped76230153_o_ped_
orbed85516193_orbed_
ordo54622353_or__do
pooped113915943pooped_
popedom1445453po_pedom
popped104117813popped_
pored85234513por_ed_
porked134717623porked_
ported94223243ported_
redo56029363__r_edo
romped114513653romped_
roped84630803ro_ped_
rouped95717353rouped_
soaped95817973soaped_
sopped114819903sopped_
sorbed94916523sorbed_
sored66141783sor_ed_
sorned74820043sorned_
sorted74523713sorted_
souped95017673souped_
stomped124110533stomped_
stooped103813833stooped_
stoped94721013sto_ped_
stopped124512203stopped_
stored75524213stor_ed_
storied8515163storied_
stormed1039043stormed_
tamped114317043tamped_
taped85327423t_aped_
tapped113820053tapped_
tardo65321103tar__do
tared69340053tar_ed_
tarred74720283tarred_
tarted74923373tarted_
temped113912893temped_
teredos839183ter_edos
termed94816703termed_
terpene92310863terpene
thorned11479403thorned_
thorpe113610093thorpe__
thorpes125010353thorpe_s
tipped114418263tipped_
tired65228903tir_ed_
tirled74714363tirled_
toed56137043to__ed_
togaed84711343togaed_
togged95117513togged_
toiled74420323toiled_
toited74016753toited_
toked105626493to_ked_
toled65934923to_led_
toledos8388863to_ledos
tolled73819033tolled_
tombed113812133tombed_
tommed113310143tommed_
tondo69718683to__ndo
toned65435343to_ned_
tonged86518903tonged_
tooled74918903tooled_
tooted74620123tooted_
tope65946383to_pe__
topee76029953to_pe_e
topees85519703to_pees
toper75231023to_pe_r
topers85025323to_pers
topes76941763to_pe_s
topo66932403to_p__o
topper103817603toppe_r
toppers113914603toppers
toppled12348843toppled_
torched133511353torched_
tore47359323tor_e__
toreador945003toreador
toreros7311343tor_eros
tores55352673tor_e_s
tories65435883torie_s
torment9316173torment
tornados945373tornados
toro48045683tor___o
toroid7416013toroid_
toroids8310643toroids
torpedoing1442383torpedoing
torpidly1483653torpidly
torpor839193torp_or
torpors939383torpors
torqued17224893torqued_
torrefy1353353torrefy
torrent7313413torrent
torrid7311853torrid_
torsade837593torsade
torse55833333torse__
torses64727953torse_s
torso56922143tor__so
torte55431703torte__
torten65314353torte_n
tortes64826053torte_s
tossed74215223tossed_
tostado895953tostado
toted64929483to_ted_
totted74319953totted_
toupee8316133toupe_e
toupees938513toupees
toured74216153toured_
tournedos1042533tournedos
toused74122013toused_
touted74419743touted_
towed95134583to_wed_
toyed96019803to_yed_
treed65626733t_reed_
tried65026913t_ried_
troked114114583troked_
tromped124210293tromped_
trooped104010723trooped_
trope75725803trope__
tropes84824353trope_s
trouped103910983trouped_
trowed104714653trowed_
trued65117693t_rued_
tumped114216233tumped_
tupelo836483t_upelo
tupped114013233tupped_
turfed103110963turfed_
turned73914473turned_
turpeth1284813turpeth
tuxedo1433133t_uxedo
typed115815453t_yped_
tyred95816433tyr_ed_
uredo65112993_ur_edo
urped84615283_urped_
warped124816413warped_
worded114316623worded_
worked145314703worked_
wormed124314303wormed_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271976.98619185.1
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.46823927.6
 
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.