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

146 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
uprooting127690(None) 
unrooting1098831unrooting
enrooting10128132enrooting
outrooting1147932outrooting
promoting1439922_promoting
proofing1439312_proofing
rooting83522432__rooting
sprouting1236942sprouting
unroofing1385702unroofing
uprating11311112upr_ating
uprousing1235622uprousing
upshooting1642552upshooting
aproning11311793apr_oning
booting103821363__booting
brooding122911373_brooding
brooking153710703_brooking
brooming132911143_brooming
crooking153611343_crooking
crooning113112113_crooning
disrooting1247743disrooting
drooling102610423_drooling
drooping12268803_drooping
footing115017593__footing
fronting12310443_fronting
frosting12311183_frosting
garoting10510703gar_oting
garotting1136103garotting
garroting1136953garroting
grooming12309513_grooming
grooving13286713_grooving
grouting103410793_grouting
hooting113919883__hooting
looting83019643__looting
marooning1238593marooning
mooting103019363__mooting
outfooting1445653outfooting
parroting1239153parroting
photoing1439073_photoing
picoting1338883_picoting
piloting1139693_piloting
pivoting1436183_pivoting
plotting113011013_plotting
poohing133112323_p_oohing
pooing93820683_p_oo_ing
pooling103219093_p_ooling
pooping123615443_p_ooping
porting103021783_p_orting
posting105622243_p_osting
potting103720893_p_otting
pouting103519943_p_outing
prating103424453_pr_ating
printing113216083_printing
probating14311193_probating
probing123314443_pr_obing
prodding13189343_prodding
profiting1549983_profiting
progging132610383_progging
prologing1338953_prologing
promoing13310463_promoing
prompting1637203_prompting
pronating12313763_pronating
pronging123511843_pronging
proponing1439993_proponing
proposing1439673_proposing
propping122811673_propping
prorating12314283_prorating
prosing103319383_pr_osing
proving134214073_pr_oving
provoking1935133_provoking
prowling1449993_prowling
purporting1543793purporting
purposing1445233purposing
rebooting12139023rebooting
reroofing1336863reroofing
rerouting10311873rerouting
rioting82716393__rioting
roofing113814353__roofing
rooking123517363__rooking
rooming104117043__rooming
roosing84018133__roosing
roosting93411463__roosting
rootling9269953__rootling
rotting82919683__rotting
routing83821093__routing
scooting113012643_scooting
scrooping1446593scrooping
shooting122812863_shooting
snooting92813203_snooting
sooting82820963__sooting
spoofing14228363sp_oofing
spooking15269803sp_ooking
spooling113212563sp_ooling
spooning112811443sp_ooning
spooring113111463sp_ooring
sporting112415463sp_orting
spotting112812093sp_otting
spouting113511953sp_outing
sprinting12310033sprinting
supporting1545563supporting
throating1398403throating
tooting83019423__tooting
trooping112710283_trooping
trotting92510913_trotting
unbolting1236453unbolting
uncoating12611923uncoating
unhooding1435893unhooding
unhooking1735353unhooking
unloosing1036113unloosing
unmooring1255813unmooring
unquoting1944763unquoting
unresting10311133unresting
unrobing1138063unr_obing
unrolling1078563unrolling
upboiling1444633upboiling
upcasting1434823upcasting
upcoiling1444793upcoiling
upcoming1535173up_coming
updarting1334333updarting
updating1236593up_dating
upflowing1842933upflowing
upfolding1642943upfolding
upgoing1135353up_go_ing
upgrowing1643123upgrowing
upholding1643373upholding
uplifting1534963uplifting
uploading1334663uploading
uppropping1352563uppropping
upraising1237263upraising
uprearing1238373uprearing
uprighting1743463uprighting
uprising1138953upr_ising
uproot8314123uproot___
uprootal1043453uproot_al
uprootals1142643uprootals
uprooted1186393uproot_ed
uprooter1085243uproot_er
uprooters1164253uprooters
uproots937143uproot__s
uprushing1544043uprushing
upsetting1275563upsetting
upsoaring1244513upsoaring
uptilting1234713uptilting
uptossing1243523uptossing
upwafting1842063upwafting
varooming1545083varooming
vrooming14287353_vrooming

Search took 7 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.483369960.7
2DLD Change Limit1486411466.12324275.8
3Display Results1461460.0632317.5
 (SQL Overall)1786911466.66926794.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.