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

96 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
taproot941267(None) 
taproom1147961taproom
taproots1047251taproots
taprooms1246662taprooms
tarot55943932ta_r_ot
uproot8314122_uproot
adroit7518793_adroit
afoot8420113_a_foot
agorot7415003_agorot
aport75432173_ap_ort
apricot111010183_apricot
apron7318833_apr_on
aprons8316993_aprons
apropos1138843_apropos
argot67728653_a_rgot
barroom1139373barroom
cahoot11416473ca_hoot
caprock1736813caprock
carpool1139223carpool
carport11316033carport
carrot8423123ca_rrot
cheroot12413693cheroot
dayroom1345233dayroom
disroot8413563disroot
enroot6615993_enroot
gadroon938173gadroon
galloot82814223galloot
galoot72719163ga_loot
haplont12412563haplont
harlot94422803ha_rlot
harpoon1238313harpoon
karoo92519583ka_roo_
karoos102415803ka_roos
karroo10410013karroo_
karroos1139313karroos
marmot10318743ma_rmot
maroon83118203ma_roon
marplot1149673marplot
outroot7516563outroot
parrot8320663pa_rrot
patriot9314533patriot
patroon92811973patroon
proof105221533__proof
prost75434103__prost
rapport11311223rapport
redroot8312903redroot
reproof1238783reproof
root45655923___root
saprobe1137333saprobe
sapwood1366913sapwood
sheroot10414373sheroot
sprout8419403_sprout
taboo73418093ta_boo_
taboos83815433ta_boos
taboret92916113taboret
takeout1149873takeout
talipot949723talipot
tandoor8278563tandoor
tapalo839793tapalo_
tapalos938813tapalos
taphole1239773taphole
tapioca1144633tapioca
tappet103820113tap_pet
tardo65321103ta_rdo_
target75028903ta_rget
taro46846913ta_r_o_
taroc75721643ta_r_oc
tarocs84615663ta_rocs
tarok97921073ta_r_ok
taroks106115283ta_roks
taros55640823ta_r_os
tarots66422993ta_rots
tarpon82812803ta_rpon
tarpons92612213tarpons
tart47566183ta_r__t
tattoo6310973tattoo_
tattoos738643tattoos
teapot8416763teap__ot
tearoom939063tearoom
throat94819753t_hroat
toot45958883t___oot
topcoat1179313topcoat
topknot1346423topknot
topmost1148173topmost
torot56139943t_or_ot
trapdoor1143653trapdoor
traprock1643483traprock
troop76417533t__roop
trooz145016153t__rooz
trot46351313t__r_ot
trout57332573t__rout
turbot8914263t_urbot
typhoon1544653typhoon
unroot6315553_unroot
uproots937143_uproots
varoom11411413va_room

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 Filter1786911340270.406440125.6
2DLD Change Limit134027966.18621666.2
3Display Results96960.0303200.0
 (SQL Overall)178691966.62226984.4
 
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.