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

114 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
upcasting143482(None) 
casting104628342__casting
pasting103826552_p_asting
recasting122414232recasting
uncasing11511002uncas_ing
updarting1334332updarting
updating1236592upda_ting
uprating11311112upra_ting
upwafting1842062upwafting
accosting1446733accosting
basting104227203__basting
blasting114013433_blasting
boasting113512503_boasting
breasting1239583breasting
canting104725903__canting
carting104228283__carting
cashing135022553__cashing
casing94829103__cas_ing
casking144317353__casking
castings113614053__castings
castling11311233__castling
catting103922643__catting
coasting113615513_coasting
costing104323023__costing
decanting132510633decanting
demasting1338453demasting
easting84924303__easting
encashing1536443encashing
encasing11610823encas_ing
encysting1544613encysting
fasting114522833__fasting
feasting122011323_feasting
furcating1537783furca_ting
gasting95022763__gasting
hasting114725193__hasting
impasting1436323impasting
incanting1289903incanting
incasing11610603incas_ing
lasting84725243__lasting
locating11311503loca_ting
masting104325823__masting
miscasting1557073miscasting
opiating11410093opia_ting
outfasting1446333outfasting
outlasting1137523outlasting
outwasting1446433outwasting
panting104025423_p_anting
parting103527383_p_arting
pashing135120513_p_ashing
passing104318423_p_assing
pastina93914593_p_astina
patting103722343_p_atting
phasing133211673_phas_ing
plaiting113113513_plaiting
planting113515383_planting
plashing143311063_plashing
plating103823073_pla_ting
platting114813033_platting
posting105622243_p_osting
prating103424453_pra_ting
precasting15169833precasting
pulsating1236343pulsating
pupating1337683pupa_ting
recanting122414823recanting
repasting122312843repasting
retasting102513413retasting
roasting93012703_roasting
scanting113914763_scanting
scarting113415263_scarting
scatting113311813_scatting
spasming13227203sp_asming
spatting113111763sp_atting
splashing1535703splashing
splatting1235983splatting
tasting84624213__tasting
toasting93410583_toasting
typecasting1951963typecasting
umlauting1243163umlauting
uncaging1268713unca_ging
uncaking1539463unca_king
uncapping1635133uncapping
uncaring11312843unca_ring
unceasing1239653unceas_ing
unclasping1544123unclasping
uncoating12611923uncoating
uncrating12813183uncrating
unhatting1335873unhatting
unlashing1336493unlashing
unmasking1635263unmasking
unplaiting1345503unplaiting
unresting10311133unresting
upcast102710093upcast___
upcasts11185643upcast__s
upcoiling1444793upcoiling
upcoming1535173upc_oming
upcurling1453493upcurling
upcurving1742563upcurving
upgazing2133313upga_zing
uplifting1534963uplifting
upraising1237263upraising
uprising1138953upris_ing
uprooting1276903uprooting
uprushing1544043uprushing
upscaling1444653upsca_ling
upsetting1275563upsetting
upstarting1343883upstarting
upswing1335593up__swing
uptalking1643353uptalking
uptilting1234713uptilting
uptossing1243523uptossing
vacating14310353vaca_ting
wasting114422843__wasting
webcasting1842483webcasting
yeasting12188923_yeasting

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.436409841.7
2DLD Change Limit1486411146.67022285.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.15224984.8
 
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.