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

109 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
roqueted183465(None) 
croqueted2143311croqueted
coquetted2154822coquetted
requested1935892requested
requited18169722requited
rocketed15157792rocketed
roquet154415892roquet__
roquets16398942roquet_s
roquette1755532roquette
roquettes1855062roquettes
rousted84013332ro_usted
routed75624332ro_u_ted
banqueted2143543banqueted
bonneted1136223bonneted
briquetted2262403briquetted
coequated2144823coequated
colleted113011663colleted
competed154113593competed
conquered2145463conquered
coquet174318013coquet__
coquetry2243563coquetry
coquets18399893coquet_s
coquette1976593coquette
coquettes2065983coquettes
corseted11311473corseted
cosseted1178343cosseted
counted103815803co_unted
courted103514923co_urted
coveted133011523co_veted
crocheted1745313crocheted
crocketed1845123crocketed
croquet1859683croquet__
croquets1955213croquet_s
croquette2043653croquette
croquettes2143543croquettes
docketed16156583docketed
doubted11307483do_ubted
dueted84113593__dueted
equated171910403_equated
frequented2343423frequented
gorgeted1135353gorgeted
grommeted1553163grommeted
grouted94111503gro_u_ted
inquieted1944253inquieted
jousted15339143jo_usted
liquated1835493liquated
louted74920693lo_u_ted
moquette1944973moquette
moquettes2044643moquettes
moulted103310313mo_ulted
mounted103611533mo_unted
ousted73720583_o_usted
outed65429063_o_u_ted
parqueted2144223parqueted
pocketed17147143pocketed
pouted94021393po_u_ted
quested17168393__quested
queued16336943__queued
quieted17309723__quieted
quoted16359453__quoted
rabbeted1334443rabbeted
racheted14149513racheted
racketed15169133racketed
rebutted11126783rebutted
refueled1286573refueled
refuted114313803refu_ted
relucted1138653relucted
reputed104613483repu_ted
requester1855513requester
required18156833required
requite162012483requite_
requiter17168643requiter
requites171511763requites
resulted939713resulted
riveted11258573r_iveted
roasted83912673ro_asted
robuster1035663robuster
rocketer14158333rocketer
rodeoed937883ro_deoed
rogered939553ro_gered
rogued84711473rogu__ed
roosted83211893ro_osted
rooted75424003ro__oted
roque144812133roqu__e_
roques154912563roqu__es
roqueting1944603roqueting
rotated82715293ro_tated
rotted74524433ro__tted
rouged86717323ro_u_ged
roughed124210943ro_ughed
rouletted1045053rouletted
rounded93013503ro_unded
rouped95717353ro_u_ped
roused75426453ro_u_sed
rouster73517083ro_uster
route55132073ro_u_te_
router65025843ro_u_ter
routes66129313ro_u_tes
roweled11269863ro_weled
rusted75020923r__usted
rutted74518403r__utted
socketed15177343socketed
sonneted936183sonneted
toileted936993toileted
toquet154414683toquet__
toquets16367863toquet_s
touted74419743to_u_ted
unquoted1836533unquoted
voluted11297943volu_ted

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621096.81321453.4
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.28224538.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.