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 “frontman” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
frontman134430(None) 
frontmen1344421frontmen
footman1236402f_ootman
frogman1335872fro_gman
frontal1038362front_al
fronton1037202front_on
ironman936612iron_man
boatman1147053_boatman
bondman1238043_bondman
foeman11311233f_o_eman
fontal9313143f_ont_al
fontina1038633f_ontina
footmen1246583f_ootmen
foreman12312363f_oreman
freedman1444143freedman
freeman1237343fr_eeman
freshman1644623freshman
frogmen1335893fro_gmen
front85029223front___
frontage1296243frontage
frontals1146273frontals
fronted114011273front_ed
fronter103611583front_er
frontes104214163front_es
frontier1147313frontier
fronting12310443fronting
frontlet1147653frontlet
frontline1245053frontline
frontons1136503frontons
frontpage15102633frontpage
fronts94415793front__s
frontward1642573frontward
funnyman1652123funnyman
grantsman1265053grantsman
ironmen936453iron_men
ironwoman1453643ironwoman
nonman8412363_non_man
outman83115033__outman
pointman1244803pointman
postman112410043_postman
potman102813573_po_tman
propman1339063pro_pman
protean92412193pro_tean
rodman949713_ro_dman
rodsman1036653_rodsman
roman75424823_ro__man
rontgen835173_rontgen
routeman10135493_routeman
strongman1243743strongman
strontian944453strontian
stuntman1072943stuntman
tongman1037573_tongman

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162527.59619242.0
3Display Results52520.0134000.0
 (SQL Overall)178691527.76523012.4
 
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.