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

189 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
frogmen133589(None) 
frogman1335871frogman
flagmen13226912flagmen
foemen11310522f_oemen
footmen1246582footmen
foramen12310532foramen
foremen12412922foremen
fragment1448372fragment
freemen1238462freemen
frogged13408492frogged
froglet11310062froglet
frontmen1344422frontmen
frozen18408442fro_zen
ironmen936452ironmen
propmen1338762propmen
ragmen93712182_ragmen
rodmen939712_rodmen
acrogen1038203acrog_en
bagmen115412533_bagmen
biogen9310253biog_en
bogymen1534763_bogymen
boogymen1643103boogymen
bookmen15126263bookmen
bowmen1399853_bowmen
broaden10289143broaden
brogan9311043brog_an
brogue94211033brogue_
brogues10719823brogues
broken124011523bro_ken
brome94421973bro_me_
bromes104719763bro_mes
bromin102615693bro_min
broomed124111053broomed
cowmen13810923_cowmen
cragsmen1344763cragsmen
crewmen1436383crewmen
cryogen1345043cryog_en
dolmen93911373_dolmen
doormen1036753doormen
dragomen1245013dragomen
draymen1335233draymen
drogue8938333drogue_
drogues9398393drogues
dromon939363dro_mon
exogen1436513exog_en
ferrymen1643943ferrymen
figment1379743f_igment
firemen1238773firemen
flagman13186173flagman
flamen115215993f_lamen
flehmen1534913flehmen
flogged13528803flogged
flogger12449463flogger
flymen14387773f_lymen
foamed126014403f_oamed
foamer114714313f_oamer
foeman11311233f_oeman
fogey125617873f_og_ey
fogged125518373f_ogged
fogger114414783f_ogger
fogie96719003f_ogie_
fogies104118063f_ogies
foment113718303f_o_ment
footman1236403footman
foramens1337823foramens
foreman12312363foreman
forge95126943forg_e_
forged115519323forg_ed
forger104820773forg_er
forges105024263forg_es
forget106326393forg_et
forgiven1542983forgiven
forgoer1137693forgoer
forgoes11311353forgoes
forgone1139343forgone
forme105225993f_orme_
formed125021173f_ormed
formee113919943f_ormee
former114221403f_ormer
formes114623713f_ormes
fragged134010163fragged
fragments1546213fragments
frame105821803fr_ame_
framed125116523fr_amed
framer114817443fr_amer
frames115119863fr_ames
freedmen1444553freedmen
freeman1237343freeman
freshen133010883freshen
freshmen1656023freshmen
friges104116483frig_es
frigged13439053frigged
frighten1566443frighten
frocked17439333frocked
froe75329993fro__e_
froes86126693fro__es
frog85624363frog___
frogeye1443813frogeye
frogeyed1642783frogeyed
frogeyes1543743frogeyes
froggier1354643froggier
frogging14358733frogging
froggy1434493frog_gy
froglets1235263froglets
frogs96220773frog__s
from96923923fro_m__
fromenty1645243fro_menty
fronded12388863fronded
fronted114011273fronted
fronter103611583fronter
frontes104214163frontes
frontman1344303frontman
fronton1037203fronton
frore86218803fro_re_
frosted113211873frosted
frothed14288783frothed
frother133110153frother
frown115415973fro__wn
frowned14348833frowned
frowner13429683frowner
froze174515653fro_ze_
frugged13387293frugged
gagmen103910413_gagmen
goodmen1135623goodmen
gripmen1235033gripmen
grommet12268453grommet
groomed11379503groomed
groomer10399873groomer
hangmen1337383hangmen
ironman936613ironman
kerogen1236093kerog_en
kronen10348913kro_nen
legmen939343_legmen
morgen9312203morg_en
nomen75621623_no_men
nonmen8412833_nonmen
omen66828183__o_men
orogeny11107023orog_eny
pirogen1038263pirog_en
plowmen1434883plowmen
potmen102713093_potmen
premen105017803pr_emen
progeny1389463prog_eny
progged12409803progged
progger11319373progger
progun968783prog_un
propman1339063propman
proven114314773pro_ven
pyrogen1337353pyrog_en
ragman94013713_ragman
ramen75625193_r_amen
regimen104411573_regimen
roamed95215093_roamed
roamer84715163_roamer
rodman949713_rodman
rodsmen1035833_rodsmen
roger64521413_rog_er
rogue66417533_rogue_
rogued84711473_rogued
rogues74617673_rogues
roman75424823_ro_man
romeo73719703_ro_meo
roomed95218543_roomed
roomer84718633_roomer
rotten64115433_rotten
rouen54920903_ro_uen
roughen11338833_roughen
roven85521973_ro_ven
rowen84921153_ro_wen
rumen74419503_r_umen
shopmen14277203shopmen
showmen15227173showmen
snowmen12246153snowmen
socmen1039193_socmen
strongmen1244323strongmen
swagmen1334973swagmen
tegmen988403_tegmen
tongmen1037123tongmen
trodden934883trodden
trogon73611753trog_on
trommel11315363trommel
vroomed13366433vroomed
wingmen1336113wingmen
women104619253_wo_men
woodmen1356053woodmen
woolmen1234973woolmen
workmen1635933workmen
yeggmen1442673yeggmen
yeomen1138183yeo_men

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.406440125.6
2DLD Change Limit1340271895.72023431.3
3Display Results1891890.0762486.8
 (SQL Overall)1786911896.20228811.8
 
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.