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

127 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
upbearing143503(None) 
unbearing1239351unbearing
uprearing1238371uprearing
uptearing1236101uptearing
appearing1436892appearing
bearing103624772__bearing
spearing113216102sp_earing
umbering1399432umbe_ring
unfearing1338882unfearing
upheaping1743852upheaping
upheaving1843802upheaving
upleaping1434362upleaping
upsoaring1244512upsoaring
upstaring1235962upstaring
anearing9413973_anearing
appealing1446493appealing
appeasing1446343appeasing
baring95135853__b_aring
beading113221863__beading
beaming123618803__beaming
beaning103820683__beaning
bearding124011943__bearding
bearings113912253__bearings
beating104326873__beating
bewaring14279493__bewaring
blaring104317113__blaring
blearing113111943_blearing
clearing113014883_clearing
cumbering16108203cumbe_ring
debeaking1735923debeaking
debearding1543733debearding
dogearing1235763dogearing
earing75235483___earing
endearing1139323endearing
fearing113520033__fearing
forbearing1644803forbearing
gearing92818843__gearing
hearing113324163__hearing
lumbering14117933lumbe_ring
nearing83020333__nearing
nonbearing1346453nonbearing
numbering14107003numbe_ring
outbeaming1546043outbeaming
outhearing1438443outhearing
outwearing1437183outwearing
paring94236493_p__aring
peacing124117073_p_eacing
peaking144317693_p_eaking
pealing104123203_p_ealing
pearling11912013_p_earling
peering103520353_p_eering
pleading123011443_pleading
pleasing112611593_pleasing
pleating112916053_pleating
prearming14139223_prearming
preparing14311643_preparing
rearing83128783__rearing
regearing112211413regearing
rehearing132211763rehearing
retearing102214253retearing
rewearing132310703rewearing
rubbering1435703rubbe_ring
sabering112113743sabe_ring
searing83330923__searing
shearing123915903_shearing
smearing113511753_smearing
sobering111912783sobe_ring
sparing104823873sp__aring
speaking153212493sp_eaking
speaning113512243sp_eaning
speering113116323sp_eering
speiring113711263sp_eiring
sphering142811943sphe_ring
spiering112713353spie_ring
spreading1339653spreading
supering11317683sup_e_ring
swearing123711443_swearing
tabering112211423tabe_ring
tearing84021493__tearing
ulcering1139333ulce_ring
unbaling11310683unb_aling
unbarring1236063unbarring
unbeing1039373unbe__ing
unbelting1237663unbelting
unbending1337463unbending
unbracing1437023unbracing
unbraking1636933unbraking
uncaring11312843u_ncaring
unceasing1239653unceasing
undaring10412753u_ndaring
unerring9311273u_nerring
unleading1138673unleading
unlearning1144713unlearning
unmeaning1237953unmeaning
unpleasing1344773unpleasing
unsealing10711043unsealing
unseaming1278113unseaming
unseating10713203unseating
unsparing1237713unsparing
unswearing1444413unswearing
unweaving1636133unweaving
upbear1096493upbear___
upbearer1243583upbear_er
upbearers1343033upbearers
upbears1195423upbear__s
upbinding1544303upbinding
upboiling1444633upboiling
upbraiding1643233upbraiding
updarting1334333up_darting
updating1236593up_dating
upending12258133up_ending
upgazing2133313up_gazing
upgrading1444903upgrading
uphoarding1742723uphoarding
uploading1334663uploading
uprating11311113up_rating
upreaching1844113upreaching
upscaling1444653upscaling
upsending1334903upsending
upsetting1275563upsetting
upspring1335703up_spring
upstaging1344113upstaging
upstarting1343883upstarting
upwelling1535233upwelling
ushering1258923ushe_ring
uttering91613083utte_ring
wearing113318863__wearing

Search took 10 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.843211970.3
2DLD Change Limit1486411278.14018260.6
3Display Results1271270.0632015.9
 (SQL Overall)1786911279.04619753.6
 
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.