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

364 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
trothing12241084(None) 
frothing15208531frothing
toothing12278861toothing
trithing122811771trithing
trotting92510911trotting
betrothing1644662betrothing
clothing14278782clothing
northing12199062northing
nothing113511902_nothing
rotting82919682_rotting
soothing12269972soothing
teething1237162teething
tithing113513892t_ithing
tooting83019422toot_ing
tootling9279522tootling
torching142510082torching
toting74123792t_ot_ing
totting82816842t_otting
trashing122613222trashing
trithings13246602trithings
troaking133310972troaking
trocking153612422trocking
troking123514102tro_king
trolling93212492trolling
tromping13319602tromping
trooping112710282trooping
trophying1844712trophying
trotline8310022trotline
trouping11249502trouping
trowing113413702tro_wing
tything14316572t_ything
worthing15178052worthing
wrathing15248922wrathing
writhing15278672writhing
airthing12297953airthing
anything1534993anything
arching136216693ar_ching
arousing93811803arousing
atrophying1943533atrophying
bathing134816243_bathing
berthing14209593berthing
birthing14338433birthing
blotching1734963blotching
blotting113910433blotting
booting103821363boot_ing
botching16359703_botching
breathing15218373breathing
broaching17287663broaching
broiling113112013broiling
broking143514823bro_king
bronzing2037693bronzing
brooding122911373brooding
brooking153710703brooking
brooming132911143brooming
brothering1646033brothering
browning14299643browning
browsing14319353browsing
brushing14359963brushing
bruting102612993brut_ing
clothings15264433clothings
clotting113110643clotting
coshing134316433_coshing
coting94629253_cot_ing
crashing143512633crashing
crating103725203crat_ing
croaking153712163croaking
crocking174313443crocking
crooking153611343crooking
crooning113112113crooning
cropping153210883cropping
crossing112612683crossing
crouching1746383crouching
crowding15247933crowding
crowing133814763cro_wing
crowning143510033crowning
crushing143010053crushing
crutching17216073crutching
doting84821913_dot_ing
dotting93314483_dotting
dratting10389653dratting
drolling103510763drolling
droning93013723dro_ning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dro_ving
drowning13298363drowning
drowsing13287773drowsing
earthing12310323earthing
emoting10313563emot_ing
eroding9314273ero_ding
erotizing1949963erotizing
faithing1537153faithing
farthing1538073farthing
footing115017593foot_ing
footling12239923footling
freshing152611023freshing
fretting122711523fretting
fritting123510703fritting
frocking18309573frocking
frogging14358733frogging
fronting12310443fronting
frosting12311183frosting
frothier1435953frothier
frothily1745303frothily
frowning15307833frowning
garoting10510703garot_ing
garotting1136103garotting
girthing13256083girthing
graphing1538533graphing
grating93923183grat_ing
gritting10309983gritting
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gro_ping
grossing103111063grossing
grouching1644943grouching
grouping12308533grouping
grousing103410453grousing
grouting103410793grouting
growing123512473gro_wing
growling1348163growling
grutching16224373grutching
hooting113919883hoot_ing
hotching17309313_hotching
hotting113116523_hotting
ironing82414013iro_ning
joshing18519413_joshing
jotting152912773_jotting
kithing153411553_kithing
knotting13236573knotting
kything18285523_kything
lathing114315693_lathing
loathing1247673loathing
looting83019643loot_ing
lotting82917753_lotting
mooching16259063mooching
mooting103019363moot_ing
morphing1637553morphing
moshing134214883_moshing
mouthing142810243mouthing
naething1236073naething
northings13185573northings
noshing114612773_noshing
notching14288583_notching
nothings12266683_nothings
noting74120153_not_ing
ohing96018813__o_hing
oohing104412933__oohing
orating83520323orat_ing
photoing1439073photoing
pithing134014053_pithing
plotting113011013plotting
plotzing20276153plotzing
pooching16328983pooching
poohing133112323_poohing
porting103021783port_ing
potting103720893_potting
prating103424453prat_ing
probing123314443pro_bing
prodding13189343prodding
progging132610383progging
promoing13310463promoing
pronging123511843pronging
proofing1439313proofing
propping122811673propping
prosing103319383pro_sing
protein92414733protein_
proteins102114283proteins
proving134214073pro_ving
prowling1449993prowling
quoting17310043quot_ing
rating74938703_rat_ing
ratting83822363_ratting
retching143412173_retching
rethink1488883_rethink
retting83425883_retting
retying113213833_retying
rioting82716393riot_ing
roaching143210433_roaching
roaming103215793_roaming
roaring82916003_roaring
robbing123313213_robbing
robing93618003_ro_bing
rocking143619633_rocking
rodding103814533_rodding
roguing9309563_roguing
roiling83220453_roiling
rolfing113710653_rolfing
rolling83620413_rolling
romping123113033_romping
roofing113814353_roofing
rooking123517363_rooking
rooming104117043_rooming
roosing84018133_roosing
rooting83522433_rooting
rootling9269953rootling
roping94023023_ro_ping
rosing73925593_ro_sing
rotating92614553_rotating
roughing13278343_roughing
rouging93114703_rouging
rouping103715793_rouping
rousing83920553_rousing
routing83821093_routing
roving103618743_ro_ving
rowing103623303_ro_wing
ruching133612933_ruching
rushing113817703_rushing
rutting82718043_rutting
scathing14269703scathing
scotching1735653scotching
scything17264883scything
seething1239023seething
shotting123012383shotting
sloshing12258823sloshing
slotting92612613slotting
smoothing1535293smoothing
sooting82820963soot_ing
sorting83221813sort_ing
southing122811823southing
spotting112812093spotting
stotting92811163stotting
stretching1645813stretching
stroking132610943stro_king
strolling10238793strolling
stropping1436933stropping
strouding1136373strouding
strowing122310563stro_wing
stroying122410593stro_ying
strutting1037003strutting
swathing15248713swathing
swotting12268483swotting
tarting84222653tart_ing
tasting84624213tast_ing
tatting84019523t_atting
tattling9259473tattling
tauting83316383taut_ing
teaching143612603teaching
teethings1344233teethings
tenting84621153tent_ing
testing86021053test_ing
thatching1835143thatching
thing96622983___thing
tholing112812333tho_ling
thorning1237513thorning
thouing11258603tho_uing
thrashing1635683thrashing
threshing1645663threshing
throating1398403throating
throbbing1743533throbbing
thronging1435073thronging
throning1238863thro_ning
throttling1442793throttling
throwing1536723thro_wing
tilting83417103tilt_ing
tinting84620603tint_ing
tithings12327693t_ithings
titling83715793t_itling
toeing74418473t_o_eing
togging103512743t_ogging
toiling83219023t_oiling
toiting83217093t_oiting
toking114420723t_o_king
toling73926123t_o_ling
tolling83418563t_olling
tombing123310533t_ombing
tomming12359243t_omming
tonging93314513t_onging
toning74025793t_o_ning
tooling82918313t_ooling
toothier1136423toothier
toothily1445523toothily
toping94122993t_o_ping
topping123514623t_opping
torquing1833843torquing
torturing1036253torturing
tossing83612563t_ossing
totaling9610303t_otaling
touching143211343touching
toughing13278553toughing
touring82915193t_ouring
tousing82916993t_ousing
touting84118453t_outing
towing103823193t_o_wing
toying105017303t_o_ying
trachling1537823trachling
tracing103720153tr_acing
tracking153715463tracking
trading93517973tr_ading
traiking132511973traiking
trailing92916093trailing
training93015863training
tramming13279343tramming
tramping132711273tramping
trancing112812023trancing
trapping132911393trapping
trawling122710783trawling
treading103515333treading
treating92519613treating
trebling1139873trebling
treeing83414303tr_eeing
trekking1235543trekking
trenching15227653trenching
trending103012833trending
trephine1338933trephine
triaging102610543triaging
trichina1348093trichina
tricing103417353tr_icing
tricking152714513tricking
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tr_ining
tripling112712553tripling
tripping133210923tripping
trochil1258713trochi_l
trochili1376943trochili
trochils1388583trochils
trollings10286693trollings
trollying1354053trollying
trophic14311033trophi_c
trophied1437643trophied
trophies13413673trophies
tropin83316753tro_pin_
tropine93116653tro_pine
tropins93116313tro_pins
troth85622203troth___
trothed114010973troth_ed
troths95414153troth__s
trotlines939103trotlines
troubling1234943troubling
trouncing1235153trouncing
troweling1376363troweling
trucing103211843tr_ucing
trucking153310163trucking
trudging11266443trudging
trueing83410183tr_ueing
truing73913933tr__uing
trumping13308733trumping
trussing9268653trussing
trusting93411653trusting
trying104214073tr__ying
trysting12267053trysting
tufting11289873tuft_ing
turtling9238833turtling
tushing114214013t_ushing
tutoring938433tutoring
tutting83515913t_utting
twitching1834243twitching
twitting12307223twitting
voting103916033_vot_ing
vrooming14287353vrooming
withing143814493_withing
wooshing1536683wooshing
wotting112913843_wotting
wreathing16266313wreathing
writing113713893writ_ing
wronging13327393wronging

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461623647.58019282.6
3Display Results3643640.1562333.3
 (SQL Overall)1786913648.15621909.1
 
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.