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

112 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
upleaping143436(None) 
upheaping1743851upheaping
beleaping1436742beleaping
leaping103215992__leaping
outleaping1346202outleaping
pleading123011442_pleading
pleasing112611592_pleasing
pleating112916052_pleating
unleading1138672unleading
unpleasing1344772unpleasing
upbearing1435032upbearing
upheaving1843802upheaving
uploading1334662uploading
uprearing1238372uprearing
uptearing1236102uptearing
appealing1446493appealing
appearing1436893appearing
appeasing1446343appeasing
blearing113111943_blearing
bleating113514503_bleating
bleeping13377933_bleeping
cleaning113112383_cleaning
clearing113014883_clearing
cleating113518143_cleating
cleaving141389683_cleaving
cleping123310423_cle_ping
coleading1338523coleading
deleading1237773deleading
deleaving1436263deleaving
duplexing2042793duple_xing
gleaming12277933_gleaming
gleaning10269323_gleaning
heaping133015853__heaping
impleading1643763impleading
leading93419553__leading
leafing113313583__leafing
leaking123616973__leaking
leaning83721203__leaning
leasing83920163__leasing
leaving114216853__leaving
nucleating1346943nucleating
outleading1237133outleading
peacing124117073_p_eacing
peaking144317693_p_eaking
pealing104123203_p_ealing
peeping123615213_p_eeping
pepping113511623_p_epping
placing123815283_pl_acing
planing103418253_pl_aning
plating103823073_pl_ating
playing133816093_pl_aying
pleaching17257083_pleaching
pleadings13285543_pleadings
pledging13276363_pledging
plopping12318703_plopping
plumping15277633_plumping
poleaxing1944873poleaxing
prepping12309763_prepping
pretaping1439133_pretaping
pulping123612323pul__ping
pulsating1236343pulsating
reaping103621213__reaping
releasing10411013releasing
repleading1436623repleading
shlepping1733393shlepping
sleaving123310983_sleaving
sleeping113812053_sleeping
sneaping11349493_sneaping
speaking153212493sp_eaking
speaning113512243sp_eaning
spearing113216103sp_earing
splaying14219303spl_aying
spreading1339653spreading
subleasing1345523subleasing
threaping15106113threaping
unbearing1239353unbearing
unceasing1239653unceasing
undraping1337333undraping
unfearing1338883unfearing
unlacing1148653unl_acing
unlading1058863unl_ading
unlaying1258363unl_aying
unlearning1144713unlearning
unleashing1444463unleashing
unloading1137193unloading
unmeaning1237953unmeaning
unsealing10711043unsealing
unseaming1278113unseaming
unseating10713203unseating
unweaving1636133unweaving
updating1236593up_dating
upending12258133up_ending
upgazing2133313up_gazing
upgrading1444903upgrading
upleap10106843upleap___
upleaped1334333upleap_ed
upleaps1185233upleap__s
upleapt11116863upleap__t
uplifting1534963uplifting
uplinking1634623uplinking
upping114013703up___ping
uprating11311113up_rating
upreaching1844113upreaching
upscaling1444653upscaling
upsending1334903upsending
upsetting1275563upsetting
upsoaring1244513upsoaring
upstaging1344113upstaging
upstaring1235963upstaring
upstepping1442103upstepping
upsweeping1861833upsweeping
upwelling1535233upwelling

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411127.09320956.0
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.57923577.1
 
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.