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

120 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
tompion1124710(None) 
tampion11298661tampion
tompions12267001tompions
campion133011412campion
lampion11278302lampion
pompon1238942pomp_on
rampion11298582rampion
tampions12358122tampions
tampon102911232tamp_on
torsion7310802torsion
amnion84812053_amnion
amotion9710473amotion
camion103917193cam_ion
campions143511293campions
champion17276353champion
coition9314313coition
common12310803com_mon
companion1577683companion
compile13312443compile
comping143518593comping
complin13312073complin
complot13310683complot
compo115318573comp_o_
compone136517193comp_one
compony1613011913comp_ony
compos124818803comp_os
cooption1288343cooption
coupon102810993coup_on
domain9511323domai_n
dominion11147033dominion
domino92611493dom_ino
doupioni1142323doupioni
emotion9711303emotion
gonion73612833go_nion
gumption1343983gumption
jomon14610083jom__on
lampions12277973lampions
lampoon11267193lampoon
logion76013723lo_gion
lomein8410203lomei_n
lotion65716523lo_tion
morion86217733mo_rion
morrion959003morrion
motion85217553mo_tion
notion64516583no_tion
onion54320973_o_nion
option83612713_option
orpin73415533_orpi_n
pion67235293___pion
pompano1345203pompano
pompom1436493pomp_om
pompons1338553pomp_ons
portion9615493portion
potion84519573po_tion
ptomain1146963ptomai_n
rampions12248023rampions
romping123113033romping
rompish1436693rompish
ronion63315643ro_nion
scorpion1244803scorpion
solion6616383so_lion
sorption1037513sorption
soupcon1144163soupcon
stomping13309763stomping
symbion1464043symbion
taction93213023taction
talion6317713t_alion
tamein8313093tamei_n
tampan102512323tamp_an
tamping122815813tamping
tampons112711563tamp_ons
tarpon82812803tarp_on
tempi94912203tempi__
temping122710693temping
tempo95214973temp_o_
tempos103812293temp_os
tenpin8310583tenpi_n
tension7311803tension
ternion739493ternion
tiepin839343tiepi_n
timpano11235863timpano
tocsin8311003tocsi_n
toman75724053tom__an
tomato8313453tomato_
tombing123310533tombing
tomboy1358213tom_boy
tomcod1135783tom_cod
tomfool1254243tomfool
tommies113812983tommies
tomming12359243tomming
tomtit8413853tomti_t
tomtits937243tomtits
toon47740633to___on
topi67830393to_pi__
topic95721503to_pi_c
topics104714583to_pics
toping94122993to_ping
topis76025833to_pi_s
topo66932403to_p_o_
topoi76018353to_p_oi
topos75726393to_p_os
topping123514623topping
topspin1145113topspi_n
torchon1237363torchon
torpid9310913torpi_d
torpids1037373torpids
torpor839193torp_or
torsions839183torsions
toxin124716713to_xi_n
toyon86715673to__yon
tromping13319603tromping
tropin83316753tropi_n
tuition738823tuition
tumping123114243tumping
turion6313163t_urion
tympan13257013tymp_an
tympano14245283tympano
typhon1436673t_yphon
utopian9126273uto_pian
youpon11366003youp_on

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.390458182.1
2DLD Change Limit1340271205.86022871.5
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.29628381.7
 
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.