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

60 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
dragomen124501(None) 
dragoman1244651dragoman
cragsmen1344762cragsmen
dragomans1343322dragomans
dragon838842drago__n
dragonet10138952dragonet
dragoon935282drago_on
draymen1335232dra_ymen
ragmen93712182_rag_men
agnomen1036763__agnomen
bagmen115412533_bag_men
bargemen1346403bargemen
brakemen1644843brakemen
cragsman1345213cragsman
dagoes85714603d_ago_es
daimen92210573d_a_imen
daysmen1335083d_aysmen
deadmen11248573dea_dmen
draftsmen1552673draftsmen
dragee84415603drag__ee
dragees9359483drag_ees
dragged11379563drag_ged
dragger10309173drag_ger
draggier11135773draggier
draggle1056103draggle_
draggled1254673draggled
draggles1145963draggles
dragline1036843dragline
dragnet91211433drag_net
dragonets11134503dragonets
dragons938383drago_ns
dragooned1242963dragooned
dragoons1045013dragoons
dragrope1243203dragrope_
dragropes1343353dragropes
dragster1034623dragster
drammed13378073dra_mmed
drayman1335433dra_yman
dromon939363dr__omon
duramen1096903dura__men
flagmen13226913flag_men
fragment1448373frag_ment
frogmen1335893frog_men
gagmen103910413_gag_men
garagemen1363763garagemen
gravamen1443933gravamen
praenomen1345013praenomen
prenomen1249633prenomen
radiomen1146633_radiomen
radome9511873_radome_
radomes10311053_radomes
ragman94013713_rag_man
ramen75625193_ra__men
regimen104411573_regimen
sagamen10127503_sagamen
swagmen1334973swag_men
trackmen1635573trackmen
tragopan1144343tragopan
trainmen1046153trainmen
trashmen1346563trashmen

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 Filter1786911461620.216827273.1
2DLD Change Limit146162607.84618628.9
3Display Results60600.0302000.0
 (SQL Overall)178691608.09222082.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.