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

118 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
tephras123628(None) 
tephra1136481tephra_
ephas10311542_eph_as
rephrase1346732rephrase
temperas12278232temperas
tempuras12295062tempuras
tepas76521682tep__as
terras63516972te_rras
tetras63017622te_tras
alphas1139513alph_as
amphoras1547083amphoras
cesuras958693cesuras
coppras13327833coppras
copras103517153cop_ras
departs104310683departs
deperms1236603deperms
deports105012883deports
epha9310053_eph_a_
ephah1337063_eph_ah
ephahs1435503_ephahs
ephedras1444413_ephedras
ephods1238363_ephods
ephoral1248403_ephoral
ephors11311403_ephors
eras45441503_e__ras
euphrasy1642473euphrasy
extras13310223_extras
eyras84715923_e_yras
fedoras1137923fedoras
hegiras1136103hegiras
hejiras1744233hejiras
lehrs86111133le_hr_s
lehuas935943le_huas
lempiras1243853lempiras
lepers84817323leper_s
nepetas935943nepetas
nephews1533323nephews
nephric1446213nephric
nephrism1544793nephrism
nephron1246653nephron
nephrons1346853nephrons
operas8312453_operas
paras76143043__paras
phrase11109903__phrase
raphias123511083raphias
remoras9314073remoras
reparks13249513reparks
reperks13298093reperks
rephrased1555283rephrased
rephrases1447413rephrases
reports94916213reports
repros84216003rep_ros
senhoras11278283senhoras
senoras72714953senoras
sepias83616103sep_ias
tahrs85412333t_ahr_s
tantras73112093tantras
tapas74627713tap__as
tapers84025813taper_s
tapirs84113173tapir_s
teargas837013teargas
tears55436463te_ar_s
teas45851493te___as
techies12513603techies
technos1236183technos
techs106915833tech__s
teguas768013te_guas
telegas837443telegas
teleran7510183teleran
telerans859473telerans
telphers1335473telphers
tempera11329043tempera_
tempers113513013temper_s
templars1255263templars
temporal1246333temporal
temporals1345293temporals
tempura11295253tempura_
tenias64720073te_nias
tenors63217753tenor_s
tenures7412013tenures
tepa66021683tep__a_
tepal76319583tep__al
tepals85415043tep_als
tepees84215243tep_ees
tephrite1346593tephrite
tephrites1446313tephrites
tepoys1137543tep_oys
terai53525483te__rai
terais64023513te__rais
terbias9310743terbias
terms75523473te__rms
terns55226873te__rns
terra54419663te_rra_
terrae62915213te_rrae
teslas64212173te_slas
tethers103815313tethers
teths85418513teth__s
tetra53417953te_tra_
tetrad73612053te_trad
tetrads82910193te_trads
tetris62816293te_tris
texas126514933te__xas
thrash12258363t__hrash
thraw1110515923t__hraw
thraws129211103t__hraws
tiaras6314553t_iaras
topers85025323toper_s
tophes115218423toph_es
tophs105220053toph__s
tophus115210363toph_us
toras55540373t__oras
tundras857113tundras
typhons1537083typhons
typhous1566323typhous
typhus14395713typh_us
urethras1174613urethras
zebras1737853ze_bras
zephyrs2441943zephyrs

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.436409841.7
2DLD Change Limit1340271187.40618097.1
3Display Results1181180.0333575.8
 (SQL Overall)1786911187.87522690.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.