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

143 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
plowmen143488(None) 
plowman1444931plowman
bowmen1399852_bowmen
cowmen13810922_cowmen
lawmen11308592_lawmen
plowed124213202plow_ed
plower114315062plow_er
potmen102713092p_otmen
propmen1338762propmen
showmen15227162showmen
snowmen12246152snowmen
adwomen1345683adwomen
albumen1135243albumen
almsmen1144583almsmen
bloomed12439433bloomed
bloomer11419813bloomer
blowed125016693blow_ed
blower115316573blow_er
blowgun1342653blowgun
blowier1248943blowier
blown105716673blow__n
blowsed13449023blowsed
blowzed22435973blowzed
bookmen15126263bookmen
bowman13129853_bowman
cloven114211513clo_ven
clowder13367933clowder
clown105214733clow__n
clowned13447723clowned
clubmen1334253clubmen
colormen1247243colormen
cowman13910373_cowman
crewmen1436373crewmen
dolmen93911373_dolmen
doormen1036753doormen
fellowmen1742923fellowmen
flagmen13226913flagmen
flamen115215993fl_amen
flehmen1534913flehmen
flowed133513763flow_ed
flower124815503flow_er
flown116213993flow__n
flymen14387773fl_ymen
foemen11310523_foemen
footmen1246583footmen
frogmen1335893frogmen
gleemen1035723gleemen
glommed13265443glommed
gloomed11337413gloomed
glowed114913833glow_ed
glower105114933glow_er
goodmen1135623goodmen
ironmen936453ironmen
lawman11289053_lawman
laymen113010843_laymen
legmen939343_legmen
limen75426033_l_imen
loamed94414613_loamed
loden66621143_lo_den
lomein8410203_lo_mein
loment84021473_lo_ment
loomed94616763_loomed
loosen66615963_loosen
louden73711793_louden
loupen84510293_loupen
lowe75435313_low_e_
lowed95233903_low_ed
lower85830413_low_er
lowes85732463_low_es
lown76929293_low__n
lowse87219903_lowse_
lumen75220903_l_umen
nomen75621623_no_men
nonmen8412833_nonmen
omen66828183__o_men
owsen84210193__owsen
packmen1746313packmen
penmen10311493p_enmen
pikemen1535333pikemen
pitmen102510793p_itmen
pivotmen1542653pivotmen
placemen1445783placemen
plasmin112410033plasmin
plasmon11257983plasmon
platen84518203pl_aten
playpen1434693playpen
plodded1265563plodded
plodder1146003plodder
plonked14348103plonked
plopped11288773plopped
plosion939113plosion
plotted104612373plotted
plotter94113663plotter
plotzed19376213plotzed
plotzes18317693plotzes
plover115312613plo_ver
plow95923233plow___
plowboy1743183plowboy
plowers123812243plowers
plowhead1742803plowhead
plowing133111723plowing
plowland1442743plowland
plows105419903plow__s
ployed124310563plo_yed
plume94819463pl_ume_
plumed114412883pl_umed
plumes104318133pl_umes
plummer13298523plummer
plummet13278353plummet
plumpen13276403plumpen
pollen83416453p_ollen
polymer1438063polymer
pome85636693p_o_me_
pomes94833933p_o_mes
pommee122813283p_ommee
pommel12277453p_ommel
postmen113110423postmen
poteen83514263p_oteen
potman102813573p_otman
powder123611903p_owder
power105325953p_ow_er
powter114116033p_owter
premen105017803p_remen
propman1339063propman
proven114314773pro_ven
prower114218123prow_er
prowled13309903prowled
prowler123310013prowler
putamen1135923putamen
rodmen939713_rodmen
rowen84921153_row_en
shopmen14277193shopmen
showman15257283showman
sloven9389633slo_ven
slowed104617073slow_ed
slower94016153slow_er
snowman12226623snowman
socmen1039193_socmen
tollmen935733tollmen
women104619253_wo_men
woodmen1356053woodmen
woolmen1234973woolmen
yeomen1138183yeo_men

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.1561145455.1
2DLD Change Limit1340271437.14018771.3
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.35924282.0
 
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.