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 “rocketry” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
rocketry174450(None) 
rockery16439251rocke_ry
crockery19356602crocke_ry
mockery18376912mocke_ry
rackety16499112racket_y
rickety16478312ricket_y
rocker124319572rocke_r_
rockers133916552rocke_rs
rocket125425282rocket__
rocketed15157792rocketed
rocketer14158332rocketer
rocketers15186882rocketers
rockets134615362rocket_s
rookery14398312rooke_ry
basketry1743513basketry
brocket154013383brocket__
brockets16328123brocket_s
cocker144320393cocke_r_
cockers153618333cocke_rs
cookery164210393cooke_ry
coquetry2243563coquetry
corsetry1365573corsetry
crocket154615673crocket__
crocketed1845123crocketed
crockets16339543crocket_s
crookery17415993crooke_ry
docker134417653docke_r_
dockers143715003docke_rs
docket134721173docket__
docketed16156583docketed
dockets144412243docket_s
grocery13336763groc_e_ry
hocker155118563hocke_r_
hockers163915913hocke_rs
hockey184813153hocke__y
jockette2165033jockette
jockey22408033jocke__y
locker124019423locke_r_
lockers133516923locke_rs
locket123922473locket__
lockets134612203locket_s
mocker143315443mocke_r_
mockers153812943mocke_rs
monkery16317453monke_ry
musketry1742183musketry
ochery14319443_oche_ry
ocker113915753_ocke_r_
ockers123813903_ocke_rs
pocket144622623pocket__
pocketed17147143pocketed
pocketer16157373pocketer
pocketers17196493pocketers
pockets154612253pocket_s
poetry1139383po__etry
puckery18306263pucke_ry
racker124824553racke_r_
rackers134320453racke_rs
racket125229423racket__
racketed15169123racketed
rackets134916873racket_s
retry84718083r___etry
rickets134915093ricket_s
rickey154613973ricke__y
robbery14348283robbe_ry
robotry1244173ro_botry
rochet115423003rochet__
rochets124213473rochet_s
rockaby1843243rock_aby
rockaway2042343rockaway
rocked135022323rocke__d
rocketeer15174493rocketeer
rocketeers16173593rocketeers
rocketing1666973rocketing
rocketries1645893rocketries
rockier134911883rockier_
rockwork1644993rockwork
rocky144513853rock___y
roguery1134893rogue_ry
ropery114313873ro_pe_ry
rosery93813283ro_se_ry
society1236083societ_y
socket123923523socket__
socketed15177343socketed
sockets134012983socket_s
toiletry1144103toiletry
trickery17297343tricke_ry
trinketry1642803trinketry
zoometry2244643zoometry

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.500357382.0
2DLD Change Limit146162887.21620255.3
3Display Results88880.0501760.0
 (SQL Overall)178691887.76623009.4
 
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.