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

117 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
gorgeted113535(None) 
corseted11311472corseted
garreted1057522garreted
gorged95016982gorg__ed
gorget87123862gorget__
gorgets94711782gorget_s
greeted93111382g_reeted
pargeted1238672pargeted
targeted1037482targeted
bogeyed1435673bo_geyed
bonneted1136223bonneted
boogeyed1543723boogeyed
borated104116363bor_ated
bordered1248933bordered
budgeted1344883budgeted
carpeted1338943carpeted
colleted113011653colleted
competed154113593competed
congeed113212313conge_ed
congested1338673congested
corbeled1338373corbeled
cornered11311133cornered
cornuted1137473cornuted
coroneted12278323coroneted
corrected1438113corrected
cosseted1178343cosseted
coveted133011523co_veted
curveted1435293curveted
docketed16156583docketed
dormered1255673dormered
ferreted1236323ferreted
fidgeted1443893fidgeted
forested12312463forested
forfeited1643793forfeited
forged115519323forg__ed
forget106326393forget__
forgets113813793forget_s
forgetter1345373forgetter
frogeyed1642783frogeyed
galleted1038213galleted
gardened1137003gardened
garget84327273garget__
gargets94614573garget_s
gargety12388043garget_y
gargled104210673garg_led
garmented1345883garmented
garnered10247113garnered
garoted9710133gar_oted
garotted1066193garotted
garroted1056783garroted
gartered10319583gartered
georgette1182373georgette
georgettes1262283georgettes
gibbeted1492783gibbeted
gimleted1243973gimleted
gingered11127743gingered
girted83912873gir__ted
gleeted9379323g_leeted
goateed9307063goate_ed
goffered1634523goffered
goggled11348953go_ggled
gonged97115913gong__ed
gored75227083gor___ed
gorge76423893gorg__e_
gorgedly1443993gorgedly
gorgeous1046293gorgeous
gorger86116983gorg__er
gorgerin1044963gorgerin
gorgers94813643gorge_rs
gorges85321893gorg__es
gormed105013833gor__med
gouged96214593goug__ed
grafted124110223g_rafted
granted94715103g_ranted
grated84523923g_r_ated
greed75125693g_r_e_ed
greened93111263g_reened
greeter82812673g_reeter
greyed114610603g_r_eyed
grieved1235283g_rieved
grifted12379583g_rifted
gritted94110903g_ritted
grommeted1553163grommeted
grouted94111503g_routed
groveled13345453groveled
grueled937133g_rueled
grunted9339283g_runted
gurged95513363gurg__ed
gurgled10399123gurg_led
gusseted1043553gusseted
gyrated12428413gyr_ated
margented1346813margented
marketed1537323marketed
mongered1238953mongered
morseled1147193morseled
orated74221503_or_ated
orbited1037733_orbited
ordered9108533_ordered
oriented937483_oriented
oughted1236223_oughted
pargetted1345663pargetted
pocketed17147143pocketed
ported94223243por__ted
portered112311533portered
rocketed15157793rocketed
rogered939553ro_gered
roqueted1834653roqueted
socketed15177343socketed
sonneted936183sonneted
sorted74523713sor__ted
togated94410663to_gated
toileted936993toileted
tormented1245963tormented
turreted935373turreted
worrited1235743worrited
worsened1236053worsened
worsted1138013wor_sted

Search took 10 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.1731032896.0
2DLD Change Limit1461621179.28015750.2
3Display Results1171170.0462543.5
 (SQL Overall)1786911179.49918811.6
 
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.