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

124 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
upraising123726(None) 
praising113214561_praising
uprising1138951upr_ising
appraising1545762appraising
braising113014562_braising
outraising1139902outraising
prising103321452_pr_ising
raising83220532__raising
reraising10313772reraising
spraining1248152spraining
upbraiding1643232upbraiding
uprating11311112upra_ting
uprisings1243342upr_isings
uprousing1235622uprousing
apprising1447963apprising
arising83619973_ar_ising
braiding123112703_braiding
brailing113514793_brailing
braining113414683_braining
brassing112612303_brassing
bruising11279143_bruising
cruising112610153_cruising
cuirassing1343023cuirassing
derailing112011313derailing
dispraising1546043dispraising
draining103312673_draining
erasing8317963_era_sing
faradising1545273faradising
fundraising1652783fundraising
graining102813183_graining
grassing103311973_grassing
harassing1346983harassing
irising83614423_ir_ising
liaising937913_liaising
misraising1348123misraising
moralising1347623moralising
mortising1238693mortising
paiking143814813_p_aiking
paining103920243_p_aining
pairing103716733_p_airing
parsing103819553_p_arsing
passing104318423_p_assing
pausing103912813_p_ausing
peising103416763_p_eising
phasing133211673_pha_sing
phrasing1438013phra_sing
plaining113911553_plaining
plaiting113113513_plaiting
poising103617103_p_oising
practising1586363_practising
prancing132612163_prancing
pranging123012723_pranging
pranking153813383_pranking
prating103424453_pra_ting
prawning1446963_prawning
praying133717323_pra_ying
precising14413273_precising
premising14412413_premising
pressing112516443_pressing
prevising15510873_prevising
pricing123417343_pr_icing
priding113317543_pr_iding
priming123417373_pr_iming
prissing113011453_prissing
prizing193514683_pr_izing
promising14410973_promising
prosing103319383_pr_osing
purposing1445233purposing
pursing103715553pur__sing
raiding93617593__raiding
railing83325643__railing
raining83922693__raining
raisin62716923__raisin_
raisings9338443__raisings
raisins72715343__raisins
raisiny10319923__raisiny
rasing74330833__ra_sing
reprising12312553repr_ising
rerising93017783rer_ising
rising74025883__r_ising
ruralising1146443ruralising
sprawling15175123sprawling
spraying14299883spra_ying
straining10410563straining
supervising1745923supervising
surmising1247683surmising
surpassing1343833surpassing
surprising1345623surprising
traiking132511973_traiking
trailing92916093_trailing
training93015863_training
traipsing1235073_traipsing
unbraiding1445123unbraiding
uncasing11511003unca_sing
unfailing1337453unfailing
unhairing1335953unhairing
unnailing1037023unnailing
unplaiting1345503unplaiting
unpromising1663623unpromising
upboiling1444633upboiling
upcasting1434823upcasting
upcoiling1444793upcoiling
updarting1334333updarting
updating1236593upda_ting
updiving1534223up_diving
upgazing2133313upga_zing
upgrading1444903upgra_ding
uppiling1335853up_piling
upraise9158603uprais__e
upraised11167413uprais_ed
upraiser10175843uprais_er
upraisers11174423upraisers
upraises10188473uprais_es
upreaching1844113upreaching
uprearing1238373uprearing
uprisen9227353upr_isen_
uprooting1276903uprooting
uprushing1544043uprushing
upsizing2035413up_sizing
uptalking1643353uptalking
uptossing1243523uptossing
upwafting1842063upwafting
urbanising1344653urbanising
utilising1046633utilising

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.420425454.8
2DLD Change Limit1486411247.45619935.8
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.92222556.3
 
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.