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

291 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
tonsils731018(None) 
tonsil6311871tonsil_
consols92914072consols
consuls92412312consuls
dossils8669772dossils
fossils10379012fossils
pensils92811592pensils
pontils9312212pontils
tahsils1035052tahsils
tansies74521242tansies
tenails73713922tenails
tensile72612732tensile
tinsels738372tinsels
tocsins939962tocsins
toenails847212toenails
toils54527492to__ils
tonics83617862ton_ics
tonsilar843952tonsilar
topsails1075092topsails
topsoils1095142topsoils
utensils8124962utensils
agnails837003agnails
anils56326723_an_ils
anvils9219713_anvils
atonias73315993aton_ias
atonics93613713aton_ics
atonies75320953aton_ies
basils85717473_basils
boils75427193bo__ils
bonnily1236873bonnily
bonspiels1342903bonspiels
bossies94116833bossies
bossily1237563bossily
brasils9410973brasils
coils75030083co__ils
confits122811423confits
congius103210073congius
conics103920593con_ics
conies84338593con_ies
conins84327233con_ins
conoids10813883conoids
consign1038773consign
consigns1137533consigns
consist9316033consist
consists10310593consists
consol82614113consol_
console92715983console
consoles103216153consoles
consul82312303consul_
consult92513633consult
consults10219983consults
cosies84932153co_sies
cosily113613853co_sily
councils1246973councils
counsels1037573counsels
cousins9516003cousins
dentils84115583dentils
donsie7613643donsi_e
donzels1735393donzels
dorsals84110843dorsals
dorsels84412573dorsels
dossals8379293dossals
dossels85511603dossels
dossil75110903dossil_
enosis63816423enosi_s
ensile62616473_ensile
ensiles72714833_ensiles
eonisms92811043eonisms
eosins64419163eo_sins
foils85025813fo__ils
fossil9379353fossil_
fusils93912343_fusils
gnosis75711213gnosi_s
gonifs104310133gon_ifs
gossips1035903gossips
gunsels8338133gunsels
hansels104011653hansels
hobnails1343303hobnails
hongies112716473hongies
honkies143015143honkies
horsily1338843horsily
hosels94218603ho_sels
housels105312133housels
instils7811453_instils
ionics84214483ion_ics
ionises72916433ionises
jonquils2442603jonquils
lentils73912973lentils
longies82916553longies
losels64714583lo_sels
lousily1038333lousily
moils76125753mo__ils
mongols103310823mongols
monies83233163mon_ies
monisms113512803monisms
monists93614783monists
monofils1346963monofils
moonsails1144493moonsails
morsels94112653morsels
mousily1239393mousily
nails55730403__nails
nils46132453__n_ils
noesis6311443noesi_s
noils55024333__noils
noisily1038403noisily
nonoily1049543nonoily
nonself1078513nonself
nonslip946553nonslip
nonsuits869153nonsuits
nonyls957853non_yls
nosily93712683no_sily
oasis56422553_oasi_s
oils46337973_o__ils
onsets64013543_onsets
onside7511803_onside
opsins8411713_opsins
ousels64815273_ousels
pansies94521983pansies
pencils113011773pencils
pensil83013333pensil_
pensile92713543pensile
podsols1056513podsols
poesies93217403poesies
pongids11347413pongids
ponies84833463pon_ies
pontil8315463pontil_
popsies112816463popsies
posies84431433po_sies
posits85718713po_sits
potsies93019483potsies
ptosis83611823pto_si_s
renails74917263renails
roils54826793ro__ils
rondels82510053rondels
ronnels7318613ronnels
rosily93914713ro_sily
rosins64521863ro_sins
snails64816653_snails
soils55327983so__ils
sonics84315633son_ics
sonnies7315223sonnies
sonships1357463sonships
sonsie6614863sonsi_e
sonsier7711743sonsier
sonsiest8313033sonsiest
stencils1046403stencils
stonily1049433ston_ily
stunsails942883stunsails
tahsil936343tahsil_
tails55634193t__ails
tanists7313653tanists
tannins72813223tannins
tarsals72512603tarsals
tarsias74013373tarsias
tassels74510853tassels
tassies74918933tassies
teasels74311313teasels
tenail64516113tenail_
tendrils946443tendrils
tenias64720073ten_ias
tennies73017973tennies
tennis64015303tenni_s
tenpins9410073tenpins
tensely1037363tensely
tenses64722553tens_es
tensible1037243tensible
tensibly1345143tensibly
tensing84616653tensing
tension7311803tension
tensions8310223tensions
tensity1039103tensity
tensive10269913tensive
tensors72712373tensors
tenuis64213083tenui_s
thesis94913733thesi_s
tils45739613t___ils
tincals93610643tincals
tineids8337873tineids
tinfoils1144323tinfoils
tinfuls1036593tinfuls
tinily94014433tin_ily
tinnily1047363tinnily
tinsel639443tinsel_
tinsnips1043733tinsnips
tipsily1236043tipsily
tmesis8529793tmesi_s
toadies82914863toadies
toasts65914993toas_ts
tobies84521023to_bies
tocsin8311003tocsi_n
toddies93011993toddies
todies74223553to_dies
toenail738783toenail_
toffies133210213toffies
toil46536283to__il_
toile54626493to__ile
toiles63923513to__iles
toits55327473to__its
tolls54728433to__lls
toluids835323toluids
toluols735823toluols
toluyls1032833toluyls
tolyls9436963to_lyls
tommies113812983tommies
tomtits937243tomtits
tonal53724303ton_al_
tonally10311373tonally
tondi65716143tondi__
tondos75115923ton_dos
tonemes9311683tonemes
toners64128003ton_ers
tones56048663ton__es
tonetics1048943tonetics
tongas74315523ton_gas
tongers84116013tongers
tonging93314513tonging
tongs65928463ton__gs
tongues879693tongues
tonic74727653ton_i_c
tonier65520713ton_ier
toniest73218903ton_iest
toning74025793ton_ing
tonish93415903ton_ish
tonishly1445523tonishly
tonlets73212503tonlets
tonners73816403tonners
tonnes65320853ton_nes
tonnish10149093tonnish
tons46553053ton___s
tonsillar943843tonsillar
tonsure758783tonsure
tonsures869133tonsures
tontine72316143tontine
tontines82114733tontines
tonus56324303ton__us
tonuses73612193tonuses
tools55325243to__ols
toonies73719883toonies
tootsies848613tootsies
topics104714583to_pics
topis76025833to_pi_s
topsail976523topsail_
topside1037733topside
topsides1137203topsides
topsoil977143topsoil_
topspins1244863topspins
torics85118353to_rics
tories65435883to_ries
toroids8310643toroids
torpids1037373torpids
torses64727953tors_es
torsi57423363torsi__
torsion7310803torsion
torsions839183torsions
torsks10549123tors_ks
torsos64815733tors_os
tortile7313193tortile
toshes94520103to_shes
toss45637973to_s__s
tossers74713503tossers
tosses65225393to_sses
tossing83612563tossing
tossups964023tossups
totals63115163to_tals
touses64229673tous_es
tousing82916993tousing
tousle64514653tous_le
tousles74113933tousles
towels94314643to_wels
towies93521193to_wies
townies103113623townies
townships1744983townships
toxics153910203to_xics
toxins133314283to_xins
toxoids1535213toxoids
trails64622513t_rails
transits8313503transits
trenails869843trenails
trochils1388583trochils
trysails1144163trysails
tunics83811263tun_ics
tunnels7328723tunnels
tunnies73614263tunnies
tussis6379953tussi_s
twibils1253113twibils
unnails738223unnails
utensil7125213utensil_
wormils1236733wormils
yonis85020823yon_i_s
zorils153810883zo_rils
zoysias1943843zoysias

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.1561145455.1
2DLD Change Limit1340272916.39020974.5
3Display Results2912910.0933129.0
 (SQL Overall)1786912916.63926915.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.