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

292 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
roquets1639894(None) 
coquets18399891coquets
croquets1955211croquets
roques154912561roque_s
roquet154415891roquet_
toquets16367861toquets
bosquets19195252bosquets
bouquets19244522bouquets
briquets1934852briquets
coquet174318012coquet_
croquet1859682croquet_
loquats1645272loquats
paroquets2043642paroquets
piquets1836602piquets
racquets1944762racquets
request16311022request
requests1735742requests
rochets124213472rochets
rockets134615362rockets
rogues74617672rogue_s
roque144812132roque__
roqueted1834652roqueted
roquette1755532roquette
roquettes1855062roquettes
rosets65819952ro_sets
rouens64814442ro_uens
roues56039352ro_ue_s
rousts617016722ro_usts
routes66129312ro_utes
routs57133412ro_u_ts
toques154612352toque_s
toquet154414682toquet_
acquest1837173acquest
acquests1944643acquests
acquits1857293acquits
baguets1037483baguets
banquets1935433banquets
baroques1934863baroque_s
bequest1837823bequest
bequests1944113bequests
bluets87215493_bluets
bonnets94812803bonnets
boskets13409473boskets
bosques18217973bosque_s
bosquet18249223bosquet_
bouquet18288263bouquet_
bouts75131313bo_u_ts
briquet1838833briquet_
brockets16328123brockets
brogues10719823brogue_s
cloques18268563cloque_s
collets93517903collets
comets105823583co_mets
conquers1938213conquers
conquest1939553conquest
conquests2045363conquests
coquetry2243553coquetry
coquette1976593coquette
coquettes2065983coquettes
coquito1845403coquito
coquitos1944703coquitos
cornets94820573cornets
corsets94819803corsets
corvets124715023corvets
cosets85824403co_sets
cossets95014283cossets
counts84618273co_unts
courts84216163co_urts
covets114819643co_vets
crochets15359833crochets
crockets16339543crockets
croqueted2143313croqueted
croquette2043653croquette
croquettes2143543croquettes
croquis1834763croqu_is
croutes94815643cro_utes
crownets13407673crownets
cruets85314953_cruets
diquats1745973diquats
dockets144412243dockets
donuts7410583donu_ts
doubts968733do_ubts
drogues9398393drogue_s
droplets1136063droplets
duets65323883__duets
fiques1837973fique_s
forgets113813793forgets
founts94313383fo_unts
frequents2144443frequents
froglets1235263froglets
gobbets12327643gobbets
goblets103210183goblets
godets8410933go_dets
goglets9379783goglets
gorgets94711783gorgets
gouts64826173go_u_ts
grommets13234663grommets
grouts75015613gro_u_ts
hoggets12498323hoggets
hornets104113553hornets
howlets13329223howlets
inquest1638603inquest
inquests1744943inquests
inquiets1745433inquiets
jousts135011273jo_usts
lockets134612203lockets
locusts9277933locusts
loggets9378913loggets
loquat1558283loquat_
louts56330273lo_u_ts
minuets9259853minuets
moppets13307163moppets
moquette1944973moquette
moquettes2044643moquettes
mosques18256913mosque_s
motets84216193mo_tets
moues75732843mo_ue_s
moults84713703mo_ults
mounts84115073mo_unts
nonets64118703no_nets
objets15125323_objets
octets839403_octets
onsets64013543_onsets
ousts55225703_o_usts
outs45746963_o_u_ts
owlets93110393_owlets
paraquets2044593paraquets
paroquet1947283paroquet_
parquets1936413parquets
picquets2143733picquets
piques1739093pique_s
piquet17412353piquet_
piroques1944353piroque_s
pockets154612253pockets
poets76024443po__ets
poppets10338853poppets
possets94212773possets
poults84613483po_ults
pouts75530323po_u_ts
prequels1934833prequels
products1376513products
projets1639163pro_jets
prophets1539503prophets
propjets1935493propjets
quest144121323__quest
quests153310353__quests
queys17398363__queys
quiets154014373__quiets
quits144122353__quits
rabbets11279423rabbets
rachets124516833rachets
rackets134916873rackets
racquet1838743racquet_
ramets83517393r_amets
ramjets1635163ramjets
rebuts84015193rebu_ts
recuts83817373recu_ts
reflets103513153reflets
refuels10399523refuels
refutes104515723refutes
reglets83512983reglets
regrets83212923regrets
relets64025673r_elets
relucts9369673relucts
remeets93712413remeets
rennets75212633rennets
reputes94615963reputes
requiems1943253requiems
requins16310203requins
requite162012483requite
requites171511763requites
resets65427613r_esets
results739833results
rets45352563r___ets
revets94022173r_evets
revues9813903revue_s
rewets94617213r_ewets
riblets93412553riblets
rickets134915093rickets
rillets74216153rillets
rivets94417113r_ivets
rivulets1174753rivulets
roadeos837403roadeos
roamers93713453roamers
roarers73812733roarers
roasts64915413ro_asts
robbers112814153robbers
robes75133303ro_be_s
robles85321693roble_s
robots8313143ro_bots
robust8310433robust_
robusta944283robusta
robustas1044353robustas
rochet115423003rochet_
rockers133916553rockers
rocket125425283rocket_
rodents8611543rodents
rodeos75314503ro_deos
rodes614039083ro_de_s
rodless8310073rodless
roes45954133ro__e_s
rogers74517913ro_gers
rogue66417533rogue__
rogued84711473rogue_d
roguery1134893roguery
roles56747983ro_le_s
rolfers104011813rolfers
rollers73117473rollers
romaunts1043693romaunts
romeos84013173ro_meos
rompers113412243rompers
rondels82510053rondels
ronnels7318613ronnels
roofers105013903roofers
roomers95416413roomers
roosers74217873roosers
rooses65526233roose_s
roosts64916323ro_osts
rooters74522933rooters
rootlets8308653rootlets
roots55933673ro__ots
ropers84325903ro_pers
ropes75940063ro_pe_s
ropiest93317773ropiest
roqueting1944603roqueting
rorquals1773173rorquals
roses56445773ro_se_s
roset55945243ro_set_
rosiest73919213rosiest
rosters73727533rosters
rotates72819773rotates
rotes56143903ro_te_s
rotguts833763rotguts
rots46454093ro___ts
rotters74421393rotters
rottes64524833rotte_s
roue45941743ro_ue__
rouen54920903ro_ue_n
rouges76022383ro_uges
roughs105416213ro_ughs
rounds73615613ro_unds
roupet84218343roupet_
roups75118903ro_u_ps
rousers75220133rousers
rouses65436283ro_uses
roust55532063ro_ust_
rout46153283ro_u_t_
route55132073ro_u_te
routed75624333ro_uted
router65025843ro_uter
routers74822853routers
routh86423073ro_u_th
rouths95416823ro_uths
rovers95423523ro_vers
roves84834483ro_ve_s
rowels94515453ro_wels
rowens94515303ro_wens
rowers94924573ro_wers
rozzers1535633rozzers
ruers515019413r__uers
rues46044483r__ue_s
runlets73310773runlets
runts55927633r__unts
russets738163russets
rusts55026993r__usts
ruts44541493r__u_ts
sequels1665703sequels
sequents1756993sequents
sockets134012983sockets
solutes73515263solutes
sonnets74211993sonnets
sorbets93012503sorbets
soviets1087293soviets
squats153712963_squats
squegs1675643_squegs
suets55126103__suets
togues76014243togue_s
toilets74112913toilets
tonlets73212503tonlets
toque145113093toque__
torquers17204303torquers
torques16217513torque_s
touts54830393to_u_ts
trouts66116623tro_u_ts
tuques15358373tuque_s
unquiets1744313unquiets
usques15126803usque_s
voguers11356683voguers
vogues104011923vogue_s
volutes102710983volutes
worsets105512843worsets
yogurts1142983yogurts

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272927.75017293.8
3Display Results2922920.0933139.8
 (SQL Overall)1786912927.99922339.2
 
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.