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

141 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
testoon74836(None) 
festoon1037671festoon
teston6313301test_on
testoons837301testoons
festoons1136432festoons
teaspoon1044412teaspoon
testons7313552testons
aswoon947013_aswoon
bassoon937613bassoon
bastion9312473bastion
benthon1237693benthon
bestow1149463best_ow
bestows1248863bestows
bestrow1237243bestrow
bestrown1345193bestrown
beton76022063be_t_on
betook12439603be_took
boston8513043bost_on
cartoon94114463cartoon
cession939813cession
cestode1037963cestode
cestoi84511953cest_oi
cestoid104011673cestoid
cestos84718093cest_os
cistron9299883cistron
destain8412083destain
destroy1138153destroy
eftsoon1043253_eftsoon
egestion946863egestion
essoin638193_essoin
estop74312103_est_op
estops84011223_estops
estrin6315923_estrin
estrone7413953_estrone
festooned1344303festooned
gentoo7311313gentoo_
gentoos838633gentoos
gossoon865663gossoon
jeton124815403je_t_on
jetton1338033je_tton
lection92614863lection
lepton82510793lept_on
lesion64715063les_ion
lesson64412043les_son
mastodon1144383mastodon
melton8311553melt_on
mention9314373mention
meson74118313mes__on
mesotron1045383mesotron
mestino9411643mestino
metopon11137073me_topon
mistook1337153mistook
nekton1036583nekt_on
nestor63713423nest_or
nestors73614973nestors
neuston736083neust_on
neutron737763neutron
newton936983newt_on
oestrin7312243oestrin
oestrone849973oestrone
peloton938743peloton
pesto75723723pest_o_
pestos84719083pest_os
piston83515923pist_on
platoon938953platoon
pontoon93010703pontoon
question1745823question
ratoon64417373_ratoon
rattoon7359243rattoon
reshoot102513893reshoot
reshown13257903reshown
resown94112923res_own
respool937633respool
restock1338673restock
restoke116113903restoke
restore75822973restore
restroom1047573restroom
retook104313443re_took
retool63914483re_tool
retorn610923423re_torn
section92515663section
session739763session
seton55223543se_t_on
sexton133610793sext_on
shoon84022003__shoon
soon46240503__s_oon
spoon74719443__spoon
stepstool1162223stepstool
stetson745783ste_tson
stolon64112073__stolon
stood65517713__stood
stook95218213__stook
stool55619893__stool
stoop75821543__stoop
swoon85014783__swoon
taction93213023taction
tattoo6310973tattoo_
tattoos738643tattoos
tearoom939063tearoom
teaspoons1143843teaspoons
teflon937453te_flon
telamon936523telamon
telethon1145993telethon
telson6310293te_lson
tendon7312033te_ndon
tenon53320513te__non
tension7311803tension
ternion739493ternion
tertian7511193tertian
test48651623test___
testa54822043test__a
testacy1235963testacy
testae64216253test_ae
testate73916233testate
testator847373testator
tested74421523test_ed
testee64323303test_ee
testees74215913testees
tester64227153test_er
testers74124543testers
testes65125823test_es
testier74015643testier
testify13246943testify
testily102910803testily
testimony1442313testimony
testing86021053testing
testis64916713test_is
tests56530193test__s
testudo843363testudo
testudos943053testudos
testy85419063test__y
tevatron1143973tevatron
textbook2141933textbook
toon47740633___toon
triton63914893trit_on
tuition738823tuition
tycoon1136023t_ycoon
typhoon1544653typhoon
upstood1044243upstood
western102911093western
yestern10338633yestern

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.1561145455.1
2DLD Change Limit1340271417.31318327.2
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.51523777.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.