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

180 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
croquet185968(None) 
coquet174318011c_oquet
croquets1955211croquets
roquet154415891_roquet
briquet1838832briquet
cloque17288742cloque_
cloques18268562cloques
coquets18399892c_oquets
crochet143616662crochet
crocket154615672crocket
croqueted2143312croqueted
croquette2043652croquette
croquis1834762croquis
croute84617272cro_ute
crownet123714112crownet
cruet74831842cr__uet
paroquet1947282paroquet
roque144812132_roque_
roques154912562_roques
roquets16398942_roquets
toquet154414682_toquet
banquet1839783banquet
baroque1835103baroque_
baroques1934863baroques
bosquet18249223bosquet
bouquet18288263bouquet
briquets1934853briquets
brocket154013383brocket
brogue94211033brogue_
brogues10719823brogues
caique17318803caique_
caiques18248793caiques
calque17289843calque_
calqued19306523calqued
calques182710193calques
casque17299273casque_
casqued19235633casqued
casques18278983casques
chaqueta2242753chaqueta
cheque2036663cheque_
chequer2135153chequer
cheques2136863cheques
cinque1736853cinque_
cinques1837333cinques
cirque1735853cirque_
cirques1836463cirques
claque17338563claque_
claquer18287343claquer
claques18279013claques
clique17289193clique_
cliqued19266683cliqued
cliques18309203cliques
cliquey21295693cliquey
closet85226603clo_set
clout75330463clo_u_t
collet84030363c_ollet
comet95946073c_o_met
conquer1838613conquer
conquest1939553conquest
coquetry2243553c_oquetry
coquette1976593c_oquette
coquito1845403c_oquito
cornet84436733c_ornet
cornute939633cornute
coronet94227173coronet
corrupt1149093corrupt
corset85636223c_orset
corslet9318063corslet
corvet114626933c_orvet
coset75748843c_o_set
cosset84125863c_osset
count74932053c_o_unt
court75532763c_o_urt
covet105638943c_o_vet
cresset93319943cresset
cricket154716953cricket
croaked143710533croaked
croaker133010683croaker
crochets15359833crochets
crocked164014433crocked
crockets16339543crockets
crocus104813173crocu_s
crocuses1239023crocuses
croft105622683cro__ft
crofter12299573crofter
crone75231333cro_ne_
crones84729243cro_nes
cronies9622503cronies
crooked143910943crooked
crooker134111093crooker
crookest1436683crookest
crooned103813343crooned
crooner93714043crooner
cropped143812063cropped
cropper133312963cropper
croqueting2243173croqueting
croquettes2143543croquettes
crore74922863cro_re_
crores86121163cro_res
crosier94116573crosier
crosse85216303crosse_
crossed105313893crossed
crosser95015463crosser
crosses94220793crosses
crossest1012012123crossest
crosslet1049593crosslet
crotchet152711993crotchet
crouch133910203cro_uch
croup95616783cro_u_p
croupe105114433cro_upe
croupes114613103croupes
croups104312553cro_ups
croupy13458733cro_upy
crouse84619363cro_use
croutes94815643croutes
crowded14418783crowded
crowder13389843crowder
crowed124717293cro_wed
crower114117553cro_wer
crowfeet1645553crowfeet
crowned133912423crowned
crowner124012593crowner
crownets13407673crownets
croze164719453cro_ze_
crozer175112843cro_zer
crozes174417663cro_zes
crozier18369933crozier
cruel74815903cr__uel
cruets85314953cr__uets
crumpet133711063crumpet
cruset84425093cr_uset
crust75827663cr__ust
cumquat2044513cumquat
drogue8938333drogue_
drogues9398393drogues
droplet10312113droplet
eloquent1745003eloquent
frequent2046423frequent
froglet11310063froglet
grommet12268453grommet
grout65330423gro_u_t
loquat1558283_loquat
paraquet1948783paraquet
paroquets2043643paroquets
parquet18311583parquet
picquet2047743picquet
piquet17412353_piquet
piroque1844353piroque_
piroques1944353piroques
prequel1836343prequel
product1279233product
projet15315183pro_jet
prophet14316033prophet
propjet1839913propjet
racquet1838743racquet
request16311023_request
robust8310433_robust
rochet115423003_rochet
rocket125425283_rocket
rogue66417533_rogue_
rogued84711473_rogued
rogues74617673_rogues
roqueted1834653_roqueted
roquette1755533_roquette
roset55945243_ro_set
roue45941743_ro_ue_
rouen54920903_ro_uen
roues56039353_ro_ues
roupet84218343_roupet
roust55532063_ro_ust
rout46153283_ro_u_t
route55132073_ro_ute
toque145113093_toque_
toques154612353_toques
toquets16367863_toquets
torque15237673torque_
torqued17224893torqued
torquer16205323torquer
torques16217513torques
trout57332573tro_u_t

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 Limit1340271805.87622809.2
3Display Results1801800.0762368.4
 (SQL Overall)1786911806.10829255.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.