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 “tepal” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
tepal7631958(None) 
sepal77723001sepal
teal45546501te_al
tepa66021681tepa_
tepals85415041tepals
tepas76521681tepas
typal105311151typal
appal95315222appal
cecal94619112cecal
copal95621782copal
deal56347412de_al
decal85523232decal
dedal75719022dedal
egal55119432_egal
feal713940422fe_al
fecal105119212fecal
feral85424652feral
fetal85623372fetal
heal75645692he_al
hemal104419802hemal
keypal1534892keypal
leal46043272le_al
legal65715942legal
meal65643172me_al
medal86221332medal
metal75427382metal
nopal75517102nopal
opal66923522_opal
pal56761672__pal
papal95820672papal
peal68648102pe_al
pedal86022502pedal
penal75228372penal
pepla9312862pepla
petal76526892petal
pipal95118352pipal
pupal97616872pupal
real45750292re_al
regal65023792regal
renal55929502renal
repay104818452repay
repeal84718282repeal
repel74921402repel
seal45654372se_al
sepals85217382sepals
septal84513382septal
seral56336382seral
setal56430902setal
steal56125472ste_al
tamal73522622tamal
tapa65129152tapa_
tapalo839792tapalo
tapas74627712tapas
tea37353322te_a_
teak85930842te_ak
teals56234132te_als
team66238652te_am
tear45242882te_ar
teas45851492te_as
teat45963632te_at
tectal83713252tectal
teel46335802te_el
tel35647902te__l
tela45532972tela_
telae54323292telae
telial65815362telial
tell44934702te_ll
tenail64516112tenail
teopan839352teopan
tepee74724212tepee
tepid8314312tepid
tepoy10312162tepoy
terai53525482terai
tergal72912832tergal
tesla55612602tesla
texas126514932texas
thecal113310302thecal
thenal92712422thenal
tical76021492tical
tidal64516442tidal
tonal53724302tonal
topaz16315322topaz
total55321822total
trepan82511672trepan
trial54926352trial
tubal75517202tubal
veal76936812ve_al
venal85523212venal
weal75838682we_al
zeal135530332ze_al

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800901.64032804.9
3Display Results90900.0165625.0
 (SQL Overall)178691901.96990752.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.