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 “uprooters” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
uprooters116425(None) 
uprooter1085241uprooter_
promoters13310092_promoters
proofers13118362_proofers
rooters74522932__rooters
uprootals1142642uprootals
uprooted1186392uproote_d
uproots937142uproot__s
brooders112610243_brooders
cooters94525723__cooters
copromoters1753983copromoters
crofters13358903_crofters
crooners103911393_crooners
footers104618333__footers
garotters1055033garotters
garroters1055813garroters
groomers11388483_groomers
groovers12337123_groovers
grouters95910083_grouters
hooters104520483__hooters
looters74419163__looters
mooters93818623__mooters
parroters1156763parroters
plotters104011553_plotters
poofters1336923_poofters
poolers94217423_p_oolers
porters93722703_p_orters
posters93928013_p_osters
potters94024343_p_otters
pouters94221873_p_outers
powters124015663_p_owters
praters94921653_pr_aters
presters103419003_presters
printers103214903_printers
probers113514583_pr_obers
proctors12311513_proctors
prodders1237463_prodders
proffers16126593_proffers
profiters14228313_profiters
proggers12258163_proggers
promoter12311453_promoter_
promotes12314123_promote_s
prompters1537553_prompters
proofer12149103_proofer_
propers113619033_pr_opers
proposers13228523_proposers
prosers94219643_pr_osers
prospers123012263_prospers
proteas92015123_pr_oteas
proteus92511593_pr_oteus
provers123817793_pr_overs
provokers1894203_provokers
prowlers13328933_prowlers
rioters73615513__rioters
roofers105013903__roofers
roomers95416413__roomers
roosers74217883__roosers
roosters83514663__roosters
rooter64926033__rooter_
rosters73727543__rosters
rotters74421393__rotters
routers74822873__routers
scooters103511033_scooters
shooters112811583_shooters
spoofers13307323sp_oofers
spoolers10349363sp_oolers
sporters103714063sp_orters
spotters104313383sp_otters
spouters104011163sp_outers
sprinters11329363sprinters
supporters1444093supporters
tooters73818773__tooters
troopers10289443_troopers
trotters83310243_trotters
unrooted9810513unroote_d
unroots738563unroot__s
updaters11255183up_daters
upholders1543643upholders
upholsters1542733upholsters
uplifters1463283uplifters
upraisers11174423upraisers
uprates93814863upr_ate_s
uprisers10206773upr_isers
uprivers13215563upr_ivers
uproars986453upr_o_ars
uproot8314123uproot___
uprootal1043453uproot_al
uprooting1276903uprooting
uprouses1037553uprouse_s
upsetters1143653upsetters
upstaters11174803upstaters
uptowners1441933uptowners
ureters7311823u_r_eters

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 Limit148641936.97021325.8
3Display Results93930.0303100.0
 (SQL Overall)178691937.42024082.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.