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

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

88 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
upleapt1111686(None) 
upleap10106841upleap_
upleaps1185231upleaps
beleapt11310252beleapt
leapt75027472__leapt
outleapt10318152outleapt
pleat74734472_plea_t
upbeat10911512upbea_t
upheap13105212upheap_
upheaps1494232upheaps
upleaped1334332upleaped
beleap10410283beleap_
beleaps1138053beleaps
bleat75737003_blea_t
clapt98027173_cl_apt
cleat76335063_clea_t
clept95725773_cle_pt
fleapit1255993_fleapit
leant56737783__leant
leap66032683__leap_
leaps75522933__leaps
least56134883__least
lept66440883__le_pt
outleap9298293outleap_
outleaps10237073outleaps
peart76440753_p_eart
peat65967933_p_ea_t
plait75631573_pl_ait
plant75437113_pl_ant
plat66048873_pl_a_t
plea66830603_plea__
pleach134211243_pleach
plead85818463_plea_d
pleads94613953_pleads
pleas75627033_plea_s
please84315733_please
pleats85218593_pleats
pliant83918823_pliant
preact103220393_preact
pulsant9310563pulsant
slept75728103_sle_pt
splat76129343spl_a_t
splent84720193sple_nt
umlaut838033uml_aut
unapt710421593u__napt
unkempt1544763unkempt
unkept123710873unke_pt
unlead73312373unlea_d
unleads8228623unleads
unlearn735953unlearn
unlearnt846403unlearnt
unleash1034963unleash
unlet54133333unle__t
unmeant9510903unmeant
unplait948603unpl_ait
unpliant1047143unpliant
unseat64221023unsea_t
unwept11389813unwe_pt
upbear1096493upbea_r
upbears1195423upbears
upbeats1195733upbeats
upcast102710093up_cast
upcoast1165543upcoast
updart9310743up_dart
updraft1346033updraft
upheaped1633643upheaped
upheave1544023upheave
upkeep1434143upkeep_
upkeeps1532193upkeeps
upland938863upl_and
upleaping1434363upleaping
uplift114610653upl_ift
uplight13167363uplight
uplit76020803upl__it
upload9257783uploa_d
uploads10266503uploads
upreach1444693upreach
uprear8168793uprea_r
uprears9107493uprears
upsent83314063upse_nt
upset73222593upse__t
upstart9159753upstart
upswept1443473upswept
uptear896783uptea_r
uptears9106453uptears
uptempo1342413uptempo
upwaft1444943up_waft
yclept1336013ycle_pt

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.403443402.0
2DLD Change Limit134027887.09618887.7
3Display Results88880.0302933.3
 (SQL Overall)178691887.52923733.7
 
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.