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

181 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
dragnet9121143(None) 
dragnets10136561dragnets
dragonet10138951dragonet
drabbet12319572drabbet
dragee84415602drag_ee
dragees9359482dragees
dragged11379562dragged
dragger10309172dragger
dragonets11134502dragonets
drained93713252drained
drainer83012842drainer
drugget10337612drugget
magnet9320662_magnet
agent65829643__agent
aglet65534143__aglet
argent74023663ar_gent
baguet9316103_baguet
bannet84925333_bannet
baronet91022203baronet
beignet101510963beignet
brachet144020313brachet
bracket154117233bracket
bragged12449843bragged
bragger113810043bragger
braggest1296533braggest
brained103816103brained
branned104311693branned
branner94212373branner
brant74742173bra_n_t
brunet84419293br_unet
carnet84732873_carnet
coagent10313983coagent
cragged12479883cragged
crane75331603cra_ne_
craned96121653cra_ned
cranes84330753cra_nes
crownet123714113crownet
cygnet1237893_cygnet
dagger95017303d_agger
dagoes85714603d_agoes
damned104212913d_amned
damner95213433d_amner
danged94819483d_anged
danger83722823d_anger
darned85018483d_arned
darnel74312183d_arnel
darner74017303d_arner
daunt65929083d_aun_t
dawned113912093d_awned
deaned84620453dea_ned
deigned1037503deigned
deraigned1244093deraigned
derange939813derange_
deranged1137693deranged
deranger1037353deranger
deranges1039973deranges
diamagnet1344953diamagnet
dipnet91317473d_ipnet
drabbed13428723drabbed
drabber12438593drabber
drabbest13295663drabbest
drabbets13294823drabbets
drabness1135803drabness
dracena1034923dracena
draft95526683dra__ft
drafted12439033drafted
draftee11379523draftee
drafter11449423drafter
drag64825053drag___
draggers11357393draggers
draggier11135773draggier
draggiest12126413draggiest
draggle1056103draggle
draggled1254673draggled
draggles1145963draggles
draggy12346823drag_gy
dragline1036843dragline_
draglines1145993draglines
dragomen1245013dragomen
dragon838843drag_on
dragons938383dragons
dragoon935283dragoon
dragooned1242963dragooned
drags75521113drag__s
dragster1034623dragster
drain65222893drain__
drainers92811253drainers
drains73719403drain_s
drake104918303dra_ke_
drakes114715863dra_kes
drammed13378073drammed
drank104816203dra_n_k
drape85319633dra_pe_
draped105314363dra_ped
draper94315693dra_per
drapes95419653dra_pes
drapey125010583dra_pey
drat56247833dra___t
dratted9358593dratted
draught12266963draught
drave95219273dra_ve_
drawee104413823dra_wee
drawees11378363drawees
drawer104711363dra_wer
drawled12368343drawled
drawler11338593drawler
drawn95614243drawn__
drayed115911393dra_yed
draymen1335233draymen
driblet103712243driblet
drogue8938333drogue_
drogues9398393drogues
drone65324983dr_one_
droned84616863dr_oned
droner74717673dr_oner
drones75023433dr_ones
droplet10312113droplet
drowned12419903drowned
drowner11369803drowner
drugged11367183drugged
druggets11313913druggets
eaglet73722583_eaglet
fragged134010163fragged
fragment1448373fragment
froglet11310063froglet
gannet74321853_gannet
garget84327273garg_et
garnet73928413_garnet
grained93814273grained
grainer83714063grainer
grange83716203grange_
granger93514213granger
granges93516523granges
grant64840023gra_n_t
grapnel1035603grapnel
magneto1046743_magneto
magnets10311143_magnets
margent10316693margent
orange74016323orange_
oranges84215333oranges
orangey11388833orangey
parget94529393parg_et
planet84228353pla_net
pranged114512553pranged
prawned1346743prawned
prawner1246803prawner
rabbet103818653_rabbet
rachet115028973_rachet
racket125229423_racket
rage55742353_rag_e_
raged74829453_rag_ed
ragee65432663_rag_ee
ragees74618663_ragees
rages64539443_rag_es
ragged94620263_ragged
raggee84217603_raggee
ragmen93712183_ragmen
ragout7317183_ragout
rained75024603_rained
ramet75743143_ra_met
ramjet15311543_ramjet
ranee55438103_ra_nee
range64728413_range_
ranged84824313_ranged
ranger73925523_ranger
ranges73826923_ranges
rant45864683_ra_n_t
reagent8716603reagent
regent74127673_regent
reglet73724233_reglet
regret73723533_regret
rennet64624853_rennet
sarsnet7314813sarsnet
signet73621153_signet
target75028903targ_et
trained84117203trained
trainee72817793trainee
trainer73316793trainer
trapnest10310923trapnest
trawlnet1146583trawlnet
urgent73816043ur_gent

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340271817.28018410.3
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.48623870.0
 
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.