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

158 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
trudgen935705(None) 
trudge8318731trudge_
trudged10298041trudged
trudgens10255141trudgens
trudgeon10253311trudgeon
trudger9338721trudger
trudges9339981trudges
drudge9317902drudge_
drudged11277612drudged
drudger10328322drudger
drudges10308872drudges
grudge9388582grudge_
grudged11317162grudged
grudger10368312grudger
grudges10349422grudges
trodden934882trodden
trudgeons11202832trudgeons
trudgers10256852trudgers
trudging11266442trudging
bludge104210973bludge_
bludged12439313bludged
bludgeon1242923bludgeon
bludger11419563bludger
bludges114511123bludges
bridge103711883bridge_
bridged12339033bridged
bridges113911333bridges
budge94619873_budge_
budged114517233_budged
budger104617703_budger
budges104820123_budges
budget104618113_budget
burden9412473burd_en
crudded1235733crudded
crude86018573crud_e_
cruder95612383crud_er
crudes96218623crud_es
cryogen1345043cryogen
cudgel1036693_cudgel
dredge9308553dredge_
dredged11346883dredged
dredger10347443dredger
dredges10379343dredges
drudgers11326843drudgers
drudgery14273633drudgery
drudging12256233drudging
drugged11367173drugged
drugget10337613drugget
drunken12263713drunken
dudeen857173_dudeen
dudgeon10134143_dudgeon
fridge11379253fridge_
fridges12369483fridges
frugged13387283frugged
fudge105315523_fudge_
fudged125212813_fudged
fudges114314493_fudges
grudgers11266743grudgers
grudging12255993grudging
grunge8359583grunge_
grunger9389783grunger
grunges93310403grunges
grutten885283grutten
gudgeon10123743_gudgeon
judge144714153_judge_
judged165911253_judged
judger154411443_judger
judges153713453_judges
kludge12407753kludge_
kludged14366523kludged
kludges13397683kludges
kludgey16384633kludgey
louden73711793loud_en
mudhen1236883_mudhen
nudge74616423_nudge_
nudged95511833_nudged
nudger85111633_nudger
nudges84114733_nudges
prude84615973prud_e_
prudent10310433prud_ent
prudes94215443prud_es
redden83613613_redden
ridden83511723_ridden
ridge75018663_ridge_
ridged94014213_ridged
ridgel8399963_ridgel
ridges85817003_ridges
rodmen939713_rodmen
rudder83812803_rudder
rude55632783_rud_e_
ruder65320543_rud_er
rugged94215373_rugged
rugger84414513_rugger
rumen74419503_ru_men
sludge84811943sludge_
sludged103610333sludged
sludges93811993sludges
smidgen11426513smidgen
smudge10387913smudge_
smudged12326463smudged
smudges11348283smudges
stridden1044273stridden
strucken1444323strucken
strudel835783strud_el
sudden83310833_sudden
tauten64311893tau_ten
thudded1333433thudded
thuggee1245263thuggee
toughen11329203toughen
trade65026043trad_e_
traded85717683trad_ed
trader75218753trad_er
trades75724493trad_es
treen55622753tr__een
triage72812893triage_
triaged92810443triaged
triages82613793triages
trident8314193trid_ent
trigged10359853trigged
trigger9329163trigger
trigon74513103tr_igon
trode65322853trod_e_
trogon73611753tr_ogon
truce75118693tru_ce_
truced95312053tru_ced
truces84916333tru_ces
trucked143910813trucked
trucker134010733trucker
truckmen1643373truckmen
true46725853tru__e_
trued65117693tru__ed
truer54916643tru__er
trues54925323tru__es
truffe1276233truffe_
truffes1356773truffes
trug55720043tru_g__
trugs65516803tru_g_s
trumped12439713trumped
trumpet113810723trumpet
trundle8307873trundle_
trundled10306393trundled
trundler9256143trundler
trundles9278473trundles
trunked12358413trunked
trunnel745403trunnel
trussed84010013trussed
trusser74010253trusser
trusses73813633trusses
trusted83412783trusted
trustee73514443trustee
truster73114313truster
tugged93813523t_ugged
tugger84013103t_ugger
turdine8310273turdine
tureen63312723t_ureen
turfmen1244163turfmen
turgent8712393t_urgent
twiggen12333503twiggen

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.1561145455.1
2DLD Change Limit1340271586.65620136.3
3Display Results1581580.0463434.8
 (SQL Overall)1786911586.85826055.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.