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

157 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
tundras85711(None) 
tundra736421tundra_
mudras94212262mu_dras
tantras73112092tantras
tunas54224122tun__as
tuners64417342tuner_s
undraw1037812_undraw
undraws1136892_undraws
andros7313303_andros
auras55932563au__ras
auroras7311703auroras
bandas95120543band_as
bandoras1138743bandoras
buckras1537343buckras
buddhas1463263buddhas
bunas75126573bun__as
bundles103515773bundles
bunds85523543bund__s
bundts95010843bund_ts
bunyas11359433bun_yas
buras74736303bu__ras
contras93015623contras
cundums1235183cundums
curaras93911953curaras
duras65727733du__ras
durras74713373du_rras
funders113813933funders
fundraise1342823fundraise
funds94119253fund__s
fundus10429173fund_us
funeral1037623funeral
funerals1146453funerals
funkias1435383funkias
gundogs1034603gundogs
hondas10313353hond_as
hundred1237143hundred
hundreds1344003hundreds
hydras13239313_hydras
indris7311963_indris
judas134911883ju_d_as
juntas134210503jun_tas
kinaras1159123kinaras
lunars65012813lunar_s
lunas55025013lun__as
madras94316433_madras
mantras93815863mantras
mudra83912433mu_dra_
muras75329583mu__ras
murras84916013mu_rras
outdrag937003outdrag
outdrags1046583outdrags
outdraw1136903outdraw
outdraws1236233outdraws
pandas95521963pand_as
pandoras11310053pandoras
panduras1136953panduras
punas74826753pun__as
pundits10379293pundits
punkas123410673pun_kas
purdas92612263purd_as
qindars17267423qindars
quadrans1866363quadrans
quadrat1769273quadrat
quadrats1866483quadrats
rotundas943573rotund_as
rundles83214713rundles
senoras72714953senoras
sundae7312873sund_ae
sundaes8313093sundaes
sunders84120053sunders
sundews11398153sundews
sundial859863sundial
sundials946753sundials
sundogs947103sundogs
sundress936983sundress
sundries9312023sundries
sundrops1145823sundrops
sundry1057943sundr_y
sunnas63914563sun_nas
sunray9310123sun_ray
sunrays1037083sun_rays
suras55336333su__ras
surras65919533su_rras
sutras64818593su_tras
tandems1037633tandems
tangram1038083tangram
tangrams1136163tangrams
tankas104613773tan_kas
tantaras8269543tantaras
tantra63713363tantra_
tenders83719723tenders
tendons8311473tendons
tendril836783tendril
tendrils946443tendrils
tends65425583tend__s
tendus75111183tend_us
tenias64720073ten_ias
tenors63217753tenor_s
tenures7412013tenures
tephras1236283tephras
terras63516973t_erras
tetras63017623t_etras
thunders1236953thunders
tiaras6314553t_iaras
tinders84219173tinders
tineas64616483tin_eas
tondos75115923tond_os
toners64128003toner_s
tongas74315533ton_gas
toras55540373t__oras
trundles9278483trundles
tuataras844863tuataras
tuateras836193tuateras
tubas75119583tu__bas
tubers85017033tuber_s
tufas85314383tu__fas
tumoral938133tumoral
tumors8810613tumor_s
tuna45127843tun__a_
tundish1137283tundish
tuner56022683tuner__
tunes55332193tun__es
tuneups933333tuneups
tungs65520633tun__gs
tunica8379813tunica_
tunicae9328143tunicae
tunics83811263tun_ics
tunnels7328723tunnels
tunnies73614263tunnies
tuns45138663tun___s
turds65021693tu__rds
turfs84620443tu__rfs
turks95320823tu__rks
turners73912893turner_s
turns55623243tu__rns
turps74918733tu__rps
tussars7359253tussars
tutors6912333tutor_s
tuyeres10417793tuyeres
tuyers94612563tuyer_s
ultras6310193_ultras
umbras1038643_umbras
unarms839243_unarms
unbars82113033_unbars
undead82711903_undead
undies73821963_undies
undoes73917403_undoes
undrape1049333_undrape
undrapes1138603_undrapes
undrawn1145293_undrawn
undress838893_undress
undrest8313013_undrest
undrew1037913_undrew
unwrap11126323_unwrap
unwraps1255513_unwraps
vandas103915993vand_as
yantras10259003yantras

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.436409841.7
2DLD Change Limit1340271576.20321606.8
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.70226662.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.