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

194 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
draymen133523(None) 
drayman1335431drayman
baymen134212002_baymen
daimen92210572d_aimen
daysmen1335082d_aysmen
deadmen11248572deadmen
dragomen1245012dragomen
drammed13378072drammed
drayed115911392dray_ed
duramen1096902dura_men
laymen113010842_laymen
ragmen93712182_ragmen
ramen75625192_ra_men
admen84516183__admen
amen66733153__a_men
arame75026623ara_me_
arames84622573ara_mes
axmen145112273__axmen
badmen114613833_badmen
bagmen115412533_bagmen
barmen105418533_barmen
batmen104414303_batmen
bayman133712703_bayman
beadmen12299453beadmen
boatmen1146913boatmen
bogymen1534763bogymen
bracken15409813bracken
brakemen1644843brakemen
brayed124615783bray_ed
brayer115315313bray_er
brazen174812453bra_zen
cabmen123610653_cabmen
carmen104019343_carmen
cayman133613213_cayman
chapmen1637283chapmen
cragsmen1344763cragsmen
crammed143710123crammed
crammer134010963crammer
craven114113933cra_ven
crayon114110003cray_on
crewmen1436373crewmen
daemon9279593d_aemon
daimon9259713d_aimon
dairymen1443313dairymen
daman84821163d_a_man
dame77140313d_a_me_
dames85435853d_a_mes
dammed124214793d_ammed
dammer114317933d_ammer
damn75724323d_a_m_n
dampen114310593d_ampen
darken114013443d_arken
daven94916473d_a_ven
dawen95413723d_a_wen
daybed13438673d_aybed
daysman1335053d_aysman
deaden83714323dea_den
deadman11238423deadman
deafen10389673dea_fen
deskmen1435023deskmen
diamin9312523dia_min
dolmen93911373d_olmen
doormen1036753doormen
doyen95014413d_oy_en
drabbed13428723drabbed
drabber12438593drabber
drabbet12319573drabbet
dracaena1142203dracaena
dracena1034923dra_cena
drafted12439033drafted
draftee11379523draftee
drafter11449423drafter
draftsmen1552673draftsmen
dragee84415603dra_gee
dragees9359483dragees
dragged11379563dragged
dragger10309173dragger
dragnet91211433dragnet
dragoman1244653dragoman
dragon838843dra_gon
dragoon935283dragoon
drain65222893dra__in
drained93713253drained
drainer83012843drainer
drake104918303dra_ke_
drakes114715863dra_kes
dram75832003dra_m__
drama85117413dra_m_a
dramas95814653dra_mas
dramedy1433243dra_medy
dramming14347563dramming
drams86025833dra_m_s
drape85319633dra_pe_
draped105314363dra_ped
draper94315693dra_per
drapes95419653dra_pes
drapey125010583dra_pey
dratted9358593dratted
drave95219273dra_ve_
drawee104413823dra_wee
drawees11378363drawees
drawer104711363dra_wer
drawled12368343drawled
drawler11338593drawler
drawn95614243dra__wn
dray85428093dray___
drayage1234423drayage
drayages1344503drayages
draying123813843draying
drays95819773dray__s
dreamed114310633dreamed
dreamer104110843dreamer
driven105210143dr_iven
dromon939363dr_omon
drummed13306323drummed
drummer12407503drummer
drunken12263713drunken
dryades12395633dryades
dryer95111463dr_y_er
duramens1195153dura_mens
dustmen1035773dustmen
examen1538283exa_men
ferrymen1643943ferrymen
flagmen13226913flagmen
flamen115215993fla_men
flymen14387773_flymen
foramen12310533fora_men
fragment1448373fragment
frame105821803fra_me_
framed125116523fra_med
framer114817443fra_mer
frames115119863fra_mes
frayed135012163fray_ed
freemen1238463freemen
frogmen1335893frogmen
gagmen103910413_gagmen
gasmen93111563_gasmen
graben9419723gra_ben
gramme114210333gramme_
grammes123611323grammes
gravamen1443933gravamen
graven104513523gra_ven
grayed115415643gray_ed
grayer106014543gray_er
greyhen1443193greyhen
gripmen1235033gripmen
headmen13259513headmen
hymen13311043__hymen
ironmen936453ironmen
jurymen1943133jurymen
kraken955883kra_ken
lawmen11308593_lawmen
layman113511303_layman
leadmen10277903leadmen
madmen113511743_madmen
meatmen1138243meatmen
oarsmen938093oarsmen
payment14310703_payment
playpen1434693playpen
prayed124815433pray_ed
prayer114815293pray_er
premen105017803pr_emen
propmen1338763propmen
ragman94013713_ragman
raiment9315413_raiment
ramee74633853_ra_mee
ramet75743143_ra_met
rammed113117303_rammed
rammer103519653_rammer
rappen103512713_rappen
ratten64217383_ratten
raven84723443_ra_ven
rayed95127503_ray_ed
rayon83815703_ray_on
rhyme13479553_rhyme_
rhymed15416713_rhymed
rhymer14387083_rhymer
rhymes14419823_rhymes
rodmen939713_rodmen
rumen74419503_r_umen
seamen84518563sea_men
skymen1535313_skymen
stamen84115943sta_men
swagmen1334973swagmen
taxmen15367443_taxmen
trackmen1635573trackmen
trainmen1046153trainmen
tramel84113713tra_mel
trammed123810713trammed
trammel11357663trammel
trashmen1346563trashmen
vanmen1138403_vanmen
yamen104115183_ya_men
yardmen1335423yardmen

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 Limit1340271946.97019229.1
3Display Results1941940.0633079.4
 (SQL Overall)1786911947.18924856.2
 
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.