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

145 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
flagman1318617(None) 
flagmen13226911flagmen
bagman114613812_bagman
flagon1037982flag_on
flagrant1247632flagrant
flamen115215992fla_men
flyman14326422fl_yman
frogman1335872frogman
gagman103811242_gagman
lagan66520342_lag_an
lawman11289052_lawman
layman113511302_layman
legman949652_legman
ragman94013712_ragman
swagman1334912swagman
adman84517903__adman
agma77623263__agma_
agmas85919873__agmas
almsman1145093almsman
ataghan1144653ataghan
ataman81013063ata_man
atman75520143__atman
axman144813183__axman
badman113813843_badman
bagmen115412533_bagmen
barman103519703_barman
batman105214063_batman
bayman133712703_bayman
beadman12249153beadman
boatman1147053boatman
cabman123812503_cabman
caiman103615663_caiman
carman103920743_carman
cayman133613213_cayman
chapman1637893chapman
clachan1437183clachan
claimant1247483claimant
clamant11312433cla_mant
clansman1245813clansman
claypan1434313claypan
clubman1344023clubman
cragsman1345213cragsman
daman84821163_da_man
deadman11238423deadman
dragoman1244653dragoman
drayman1335433drayman
fagin9216573f_ag_in
filarian1148313filarian
fireman1249333fireman
firman112211343f_irman
flacon1138633fla_con
flag87427083flag___
flagged13459633flagged
flagger12469353flagger
flagging14329223flagging
flaggy14415923flag_gy
flagons1137973flagons
flagrance1544193flagrance
flagrancy1852943flagrancy
flags95321283flag__s
flam96333293fla_m__
flambe13489153fla_mbe
flame105124443fla_m_e
flamed124618973fla_med
flamens124611063fla_mens
flamer114919123fla_mer
flames114723693fla_mes
flaming134216443fla_ming
flammed15377413flammed
flamming16357153flamming
flams105125013fla_m_s
flamy135217473fla_m_y
flan76134183fl___an
flanken14226763flanken
flatcap1463653flatcap
flatcar1274613flatcar
flatland1264963flatland
flatmate1346393flatmate
flatten10429653flatten
flauta937823flauta_
flautas1036153flautas
flavin1239303fla_vin
flaxen16518573fla_xen
flehmen1534913flehmen
flymen14387773fl_ymen
foeman11311233f_oeman
footman1236403footman
foreman12312363foreman
fragment1448373fragment
fragrant1247113fragrant
freeman1237343freeman
frogmen1335893frogmen
gagmen103910413_gagmen
gasman92911743_gasman
glassman1145183glassman
gleeman1035363gleeman
hangman1337813hangman
headman13229633headman
lagans75717783_lag_ans
lagoon7410483_lagoon
laguna7127223_laguna
lallan63414173_lallan
lama66635293_la_ma_
lamas75532793_la_mas
landman1038923_landman
lauan55216793_la_uan
lawmen11308593_lawmen
laymen113010843_laymen
leadman10237843leadman
legmen939343_legmen
leman75622603_l_eman
ligan67920283_lig_an
lignan75510323_lignan
liman75921603_l_iman
llama799893lla_ma_
llamas888973lla_mas
logan68123283_log_an
madman113712383_madman
magian9312833_magian
magma104513573_magma_
magmas115512503_magmas
meatman1137903meatman
pagan86121163_pag_an
placeman1445683placeman
plagal948573plag_al
plasma103810913plasma_
plasmas113010753plasmas
plasmin112410033plasmin
plasmon11257983plasmon
platan83913693pla_tan
plowman1444933plowman
raglan73711503_raglan
ragmen93712183_ragmen
sagaman10117563_sagaman
seaman84015903sea_man
shaman113314283sha_man
slogan7539223slog_an
swagmen1334973swagmen
taxman15328613_taxman
tongman1037573tongman
ulama7711473ula_ma_
ulamas8910453ula_mas
vanman1139793_vanman
wingman1336383wingman
yeggman1442923yeggman

Search took 7 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 Limit1340271456.00022337.8
3Display Results1451450.0502900.0
 (SQL Overall)1786911456.19028867.7
 
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.