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

132 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
tennists829779(None) 
tennises82810131tennises
tennist72813111tennist_
dentists939262dentists
enlists749392_enlists
sennits73811282senni_ts
tanists7313652t_anists
tennies73017972tenni_es
tennis64015302tenni__s
tenorists948192tenorists
agonists9289833agonists
bemists113410703be_mists
bennets94712163benn_ets
bennies93917313benni_es
bennis84314803benni__s
bundists1145383bundists
canonists1158513canonists
cellists1038563cellists
centrists11410233centrists
consists10310593consists
deists74916433de__ists
delists84414173de_lists
demonists1248703demonists
dentist8316743dentist_
desists83611723de_sists
detentists1145503detentists
egoists887073_egoists
encysts1244313_encysts
enlist6417043_enlist_
entwists1156143_entwists
eonisms92811043_eonisms
eternises9119453eternises
exists134710913_e_xists
feists94915313fe__ists
feminists14227623feminists
fenniest113113203fenniest_
feudists1244463feudists
genoises939253genoises
hedonists1346053hedonists
heists96814633he__ists
henbits12177003henbi_ts
hennish1336863hennis_h
hornists11208833hornists
hymnists1644903hymnists
insists739083_insists
internists10410243internists
ironists839293ironists
jennets14517633jenn_ets
jennies143511623jenni_es
kennings13315273kennings
leftists11235513leftists
legists899593le_gists
lentisks1244413lentisks
lutenists956593lute_nists
melanists1148623melanists
metrists1039853metrists
monists93614783_monists
onanists838413onanists
penises9318193pe_nises
pennants1037063pennants
pennies94218813penni_es
pennines103112043pennines
pennis84315743penni__s
peonisms1238443peonisms
persists1049183persists
pianists1049013pianists
plenists1038253plenists
realists83014843realists
reenlists946263reenlists
reknits1137073rekni_ts
relists73817053re_lists
renests74014213re_nests
rennases848983rennases
rennets75212633renn_ets
rennins74013413renni_ns
resists74414923re_sists
retwists1135603retwists
revuists1135153revuists
sennets73712583senn_ets
sennights1343433sennights
sennit63117923senni_t_
sexists14267673se_xists
tachists1348183tachists
tanist6324593t_anist_
tannest72617853tannest_
tannings9268633tannings
tannins72813223tanni_ns
tannish101610573tannis_h
teeniest82112413teeniest_
teleosts846423teleosts
telnets738373teln_ets
tempests1234443tempests
tenails73713923tenai_ls
tenants7311013te_nants
tenebrists1243593tenebrists
tenets65518953te_n_ets
tenias64720073te_ni_as
teniases838623teniases
teniasis846063teniasis
tenners74014923tenn_ers
tenorist8413023tenorist_
tenpins9410073tenpi_ns
tenses64722553te_n_ses
tensest72713313tensest_
tensions8310223tensions
tensity1039103tensi_ty
tentiest82115613tentiest_
tents56434213te_n__ts
tenuis64213083tenui__s
tenuity1037453tenui_ty
ternions838813ternions
territs72714503terri_ts
tests56530193te___sts
tetanises979873tetanises
theists1039153t_heists
theorists1246603theorists
tinniest82911463tinniest_
tinnitus843783tinnitus
titlists837293titlists
tonnish10149093tonnis_h
tourists838313tourists
transits8313503transits
tsarists857303tsarists
tubaists1055103tubaists
tubists9288323t_ubists
tunnies73614263tunni_es
twists9549753t__wists
typists1236173t_ypists
tzarists1755693tzarists
verists103613673ve_rists
wenniest11259593wenniest_
wennish1336243wennis_h

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621326.86021306.4
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.34624324.9
 
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.