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

165 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
yardman133591(None) 
yardmen1335421yardmen
adman84517902_a_dman
aidman92410622_aidman
badman113813842ba_dman
barman103519702bar_man
birdman1236672birdman
boardman1344392boardman
carman103920742car_man
hardpan1336442hardpan
herdman13238422herdman
landman1038922landman
madman113712382ma_dman
oarsman937732oarsman
sandman10310172sandman
yardland1343762yardland
yardwand1642742yardwand
admen84516183_a_dmen
aidmen92610373_aidmen
airman82414223_airman
aroma71220143_aroma_
aromas81018613_aromas
ashman1148383_ashman
ataman81013063_ataman
atman75520143_a_tman
axeman1538103_axeman
axman144813183_a_xman
badmen114613833ba_dmen
bagman114613813ba_gman
bandsman1346753bandsman
barchan1469133barchan
bargeman1345143bargeman
barmen105418533bar_men
baseman1138553baseman
batman105214063ba_tman
batsman1157993batsman
bayman133712703ba_yman
beadman12249153beadman
birdmen1235833birdmen
boardmen1344073boardmen
bondman1238043bondman
cabman123812503ca_bman
caiman103615663ca_iman
caravan1239223caravan
cardamon1345553cardamon
cardia9916373cardia_
cardiac1278813cardiac
cardiae10713703cardiae
cardias10715093cardias
cardigan1245613cardigan
cardon94120853card_on
cardoon104813813cardoon
carmen104019343car_men
caveman1437073caveman
cayman133613213ca_yman
dairyman1443493dairyman
daman84821163da__man
darshan1167063darshan
daysman1335053daysman
deadman11238423deadman
drayman1335433drayman
earthman1346473earthman
fireman1249333fireman
firman112211343fir_man
foreman12312363foreman
gagman103811243ga_gman
garda7316763gard_a_
gardai839663gard_ai
gardant9314463gard_ant
garden84215083gard_en
gasman92911743ga_sman
gateman1057463gateman
german9611983ger_man
goodman1135933goodman
guardian1045113guardian
guardsman1342523guardsman
hackman1836433hackman
handyman1745223handyman
hangman1337793hangman
hanuman1237123hanuman
harden105718533hard_en
hardhat14411023hardhat
hardpans1436453hardpans
harijan1735783harijan
harmin113117393har_min
headman13229633headman
herdmen13238453herdmen
herdsman1465643herdsman
jazzman2442553jazzman
jordan1468063jord_an
juryman1943583juryman
karma113415003kar_ma_
karmas123013733kar_mas
kirkman1243773kirkman
landmen1038553landmen
landsman1156853landsman
lardon74415063lard_on
lardoon83410373lardoon
lawman11289053la_wman
layman113511303la_yman
leadman10237843leadman
lurdan738363lurd_an
madmen113511743ma_dmen
mailman1137733mailman
marksman1645263marksman
martian93514683martian
merman10513853mer_man
oarsmen938093oarsmen
packman1736693packman
pardah123412823pard_ah
pardon94618733pard_on
parian83223963par_ian
partan83820563par_tan
preman104117453_preman
radian74117273ra_dian
ragman94013713ra_gman
randan7315253rand_an
reedman1037723reedman
reman75730153__reman
rodman949713_rodman
roman75424823__roman
sagaman10117553sagaman
sandmen1039413sandmen
saran53730303sar__an
sardana838643sard_ana
sardar73013173sard_ar
seedman1037373seedman
surfman1236203surfman
swordman1443403swordman
tarama8412723tarama_
taramas9612693taramas
tardyon1134673tardyon
tarmac10310333tar_mac
tarpan82814293tar_pan
tartan64217513tar_tan
tarzan152910753tar_zan
taximan1635783taximan
taxman15328613ta_xman
turfman1243983turfman
vanman1139793va_nman
wadmal1237283wa_dmal
warden104515513ward_en
wireman1237843wireman
woodman1336313woodman
workman1635613workman
yachtman1842653yachtman
yamen104115183ya__men
yamun10419273ya__mun
yard85633253yard___
yardage1235733yardage
yardarm13114533yardarm
yarded114714023yard_ed
yarder103813973yard_er
yarders113211593yarders
yarding123413143yarding
yardlands1443583yardlands
yards95324613yard__s
yardwands1742683yardwands
yarn75230043yar___n
yashmac1742563yashmac
yashmak1942743yashmak
yasmak1534593ya_smak
yatagan1144133yatagan
yeggman1442923yeggman
yeoman1138823y_eoman

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271657.98316789.1
3Display Results1651650.0463587.0
 (SQL Overall)1786911658.16921874.3
 
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.