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

248 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
tennises8281013(None) 
tennies73017971tenni_es
tennists8297791tennists
bennies93917312benni_es
eternises9119452eternises
genoises939252genoises
jennies143511622jenni_es
penises9318192pe_nises
pennies94218812penni_es
pennines103112042pennines
rennases848982rennases
teniases838622teniases
tennis64015302tenni__s
tennist72813112tennis_t
tenses64722552te_n_ses
tetanises979872tetanises
tunnies73614262tunni_es
adonises92611433adonises
aegises8311373ae_gises
agonises92613163agonises
anises64826693__anises
beanies93821093beani_es
bennes86019013benn__es
bennis84314803benni__s
benzines1938213benzines
betises94816123be_tises
blennies1056933blenni_es
bunnies94415003bunni_es
canonises11410803canonises
censes83721803ce_n_ses
censuses10187543censuses
centeses1079443centeses
centiles103615813centiles
centimes124012613centimes
cercises12410933cercises
cerises94722253ce_rises
cognises11610043cognises
connives1339723connives
deixises1635693deixises
demises103719563de_mises
demonises12311093demonises
denies74729643de_ni_es
dentines93418403dentines
dentists939263dentists
dermises112512023dermises
derrises93012783derrises
despises1139433despises
devises114116763de_vises
dunnites947173dunnites
ebonises1039223ebonises
egises7312493_e_gises
encases93116053_encases
endites83717063_endites
endives113710693_endives
engines81114463_engines
enisles72312603_e_nisles
enlists749393_enlists
enosises8311003_enosises
ensiles72714833_ensiles
entases72816273_entases
entices91616333_entices
entires71517783_entires
envies9314053_envi_es
eonisms92811043_eonisms
eternise8119663eternise_
eternised10116273eternised
eternizes18118013eternizes
ethnoses1146083ethnoses
excises1638933_excises
fannies103415643fanni_es
feminises14229753feminises
fennier10339253fenni_er
fenniest113113203fenniest
finises10312903_finises
funnies104113603funni_es
geneses82613523ge_neses
genies75324943ge_ni_es
geniuses935933geniuses
genoise839423genoise_
gentiles93713523gentiles
genuses83510883ge_nuses
gunnies83413123gunni_es
heinies102514543heini_es
hennish1336863hennis_h
henries102718283henri_es
hinnies103615103hinni_es
incises93414893_incises
ionises72916433_ionises
itemises1087693ite_mises
kennings13315273kennings
kenosises1345143kenosises
kermises14248313kermises
kernites1269113kernites
kyanises15206393kyanises
lenites7818443le_nites
lenses64620893le_n_ses
lentisks1244413lentisks
lewises1039133le_wises
lionises8310313lionises
mannites10312613mannites
mannoses1039083mannoses
mantises10317923mantises
meanies93620743meani_es
meinies92516073meini_es
meninges1137433meninges
menses84222453me_n_ses
merises93421423me_rises
minnies93617363minni_es
nannies73015203nanni_es
ninnies73713613ninni_es
noises65021853__noises
ozonises1776373ozonises
peises84125043pe__ises
pelvises1337273pelvises
penalises11912773penalises
penknives1842393penknives
penlites10312273penlites
pennames12287793pennames
penniless1144013penniless
pennine93712953pennine_
pennis84315743penni__s
pentoses10312893pentoses
peonies93620153peoni_es
peonisms1238443peonisms
pinnies93318443pinni_es
realises82420183realises
remises93423483re_mises
rennase738713rennase_
rennins74013413renni_ns
reprises102615463reprises
reraises8415643reraises
rerises73525883re_rises
reunites8312473reunites
revises104220533re_vises
seises64026713se__ises
semises93916553se_mises
seniles72618023se_niles
sennits73811283senni_ts
senses63923943se_n_ses
sonnies7315223sonni_es
stannites947023stannites
stenoses8310443ste_noses
sternites9310073sternites
sunrises8310693sunrises
tabbises12236523tabbises
taeniases944333taeniases
tallises82713263tallises
tamises92715973t_amises
tanists7313653t_anists
tannages9228963tannages
tannates81911953tannates
tannings9268633tannings
tannins72813223tanni_ns
tannish101610573tannis_h
tansies74521243tansi_es
tapises92914013t_apises
tarnishes12188893tarnishes
tawnies102812503tawni_es
teases65426273te__ases
teatimes1039443teatimes
techies12513603techi_es
tectites1039993tectites
teddies92711283teddi_es
teenier72611143teeni_er
teeniest82112413teeniest
teensier835573teensier
teensiest945833teensiest
tekkies1035943tekki_es
tektites1236613tektites
teleses7313123te_leses
televises1246353televises
tellies73820503telli_es
tenaces92814513te_naces
tenailles946323tenailles
tenails73713923tenai_ls
tenancies1149173tenancies
tenches123515523te_nches
teniae64517353te_niae_
tenias64720073te_ni_as
teniasis846063teniasis
tenner64117103tenn__er
tenners74014923tenn_ers
tenorists948193tenorists
tenorites9311093tenorites
tenpins9410073tenpi_ns
tense55225843te_n_se_
tensed74817833te_n_sed
tenser64919433te_n_ser
tensest72713313te_n_sest
tensile72612733tensile_
tensions8310223tensions
tensities9311333tensities
tensive10269913tensive_
tentages91011043tentages
tentie62521183tenti_e_
tentier73815923tenti_er
tentiest82115613tentiest
tentless8229843tentless
tenues63816443te_n_ues
tenuis64213083tenui__s
tenuities949763tenuities
tenures7412013te_nures
tergites9310543tergites
termites10313693termites
ternes65422903tern__es
ternions838813ternions
terrases82111483terrases
terries73425633terri_es
terrines82117553terrines
tetanies8513553tetani_es
tetanise8610203tetanise_
tetanised1096513tetanised
tetanizes1889843tetanizes
tetanuses984613tetanuses
texases1437573te_xases
textiles1536833textiles
theorises1247813theorises
tininess8310633tininess
tinnier72910143tinni_er
tinniest82911463tinniest
tinniness936093tinniness
tinnitus843783tinnitus
tinnituses1062763tinnituses
tonnages9187873tonnages
tonnes65320853tonn__es
tonnish10149093tonnis_h
tontines82114733tontines
tonuses73612193t_onuses
toonies73719883tooni_es
townies103113623towni_es
trannies8415013tranni_es
treatises9310373treatises
trellises947023trellises
trendies9312213trendi_es
tundishes1344543tundishes
tunnages9195903tunnages
tussises835433tussises
tweenies11146393tweeni_es
twenties1137503twenti_es
tyrannises1383973tyrannises
venines103516613ve_nines
venires103012453ve_nires
venuses103111413ve_nuses
vernixes1836053vernixes
weenies102915093weeni_es
wennier10318603wenni_er
wenniest11259593wenniest
wennish1336243wennis_h

Search took 9 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.423422437.4
2DLD Change Limit1461622487.75018859.6
3Display Results2482480.1102254.5
 (SQL Overall)1786912488.28321573.2
 
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.