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

175 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
crockery1935660(None) 
crookery17415991crookery
rockery16439251_rockery
clocker153910872clocker_
clockers16369812clockers
cocker144320392c_ocker_
cockers153618332c_ockers
cookery164210392c_ookery
cracker153114172cracker_
crackers164111722crackers
crickey18418142cricke_y
croaker133010682croaker_
croakers14288522croakers
crocked164014432crocke_d
crocket154615672crocke_t
crockets16339542crockets
crooker134111092crooker_
grocery13336762groc_ery
mockery18376912_mockery
rocker124319572_rocker_
rockers133916552_rockers
rocketry1744502_rocketry
rookery14398312_rookery
trickery17297342trickery
archery15478063ar_chery
blocker15419923blocker_
blockers16398793blockers
brocket154013383brocke_t
brockets16328123brockets
broguery1443313broguery
broidery14356083broidery
broker124314243bro_ker_
brokers133111913bro_kers
checker18329533checker_
checkers19317843checkers
chickory2243363chickory
chocked194411613chocke_d
choker154314373cho_ker_
chokers164311523cho_kers
chokey184811713cho_ke_y
clacker153813773clacker_
clackers163911703clackers
clicker154111883clicker_
clickers163910203clickers
clocked164112833clocke_d
clovery15407403clo_very
clownery1633313clownery
cocked155022563c_ocke_d
cockered17710213c_ockered
cockerel16107113c_ockerel
cockeye1867223c_ockeye
cockier154013623c_ockier_
cockily1838493c_ockily
cockney1835873c_ockney
cockshy2143223c_ockshy
cocky164215933c_ock__y
conker124721553c_onker_
conkers133721043c_onkers
cooker124722453c_ooker_
cookers134619463c_ookers
cookey155414333c_ooke_y
coopery143910273c_oopery
coppery16409393c_oppery
corker124720853c_orker_
corkers134118853c_orkers
cracked163514743cracke_d
crackly18397703crack_ly
cracky175010223crack__y
cranker133612793cranker_
creamery15385983creamery
cricked164814283cricke_d
cricket154716953cricke_t
crickets16418123crickets
crikey15317783cr_ike_y
croaked143710533croake_d
croakier14436263croakier_
croakily1744733croakily
croaky15528483croak__y
crocein1138073croc_ein
crochet143616663croche_t
crochets15359833crochets
crock135921993crock___
crockeries1857113crockeries
crocketed1845123crocketed
crocking174313443crocking
crockpot1844293crockpot
crocks145118423crock__s
crofter12299573crofter_
crofters13358903crofters
crooked143910943crooke_d
crookedly1942033crookedly
crookest1436683crookest
crooner93714043crooner_
crooners103911393crooners
cropper133312963cropper_
croppers143311483croppers
crosier94116573crosier_
crosiers103312063crosiers
crosser95015463crosser_
crossers103912703crossers
crotchety19403813crotchety
crousely1346563crousely
crowberry1942373crowberry
crowder13389863crowder_
crowders14398813crowders
crower114117563cro_wer_
crowers124614903cro_wers
crowner124012603crowner_
crowners133710753crowners
crozer175112843cro_zer_
crozers184111083cro_zers
crozier18369933crozier_
croziers19287003croziers
cutchery18265173cutchery
cyclery1763493c_yclery
docker134417653_docker_
dockers143715003_dockers
drollery12314793drollery
flackery20295243flackery
flickery20365103flickery
frocked17439333frocke_d
grocer94212143groc_er_
grocers103511253groc_ers
groggery1433513groggery
hocker155118563_hocker_
hockers163915913_hockers
hockey184813153_hocke_y
jockey22408033_jocke_y
knackery16283663knackery
knocker12296393knocker_
knockers13285733knockers
locker124019423_locker_
lockers133516923_lockers
mocker143315443_mocker_
mockers153812943_mockers
monkery16317453_monkery
ochery14319443__ochery
ocker113915753__ocker_
ockers123813903__ockers
pricker154013413pricker_
prickers163710673prickers
puckery18306263_puckery
quackery2633113quackery
racker124824553_racker_
rackers134320453_rackers
rackety16499113_rackety
rickety16478313_rickety
rickey154613973_ricke_y
robbery14348283_robbery
rockaby1843243_rockaby
rocked135022323_rocke_d
rocket125425283_rocke_t
rockets134615363_rockets
rockier134911883_rockier_
rocky144513853_rock__y
roguery1134893_roguery
ropery114313873_ro_pery
rosery93813283_ro_sery
shocker163411433shocker_
shockers17319463shockers
snickery17295543snickery
sorcery1237033sorc_ery
spookery17264143spookery
stocker133713083stocker_
stockers143411073stockers
tracery12399793trac_ery
tracker133515173tracker_
trackers143512853trackers
tricker134615523tricker_
trickers143812813trickers
trocked144312243trocke_d
trucker134010733trucker_
truckers14279013truckers
wrecker16367603wrecker_
wreckers17315973wreckers

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.420425454.8
2DLD Change Limit1461621756.61022112.3
3Display Results1751750.0632777.8
 (SQL Overall)1786911757.09325192.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.