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

159 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
propman133906(None) 
propmen1338761propmen
frogman1335872frogman
gripman1234462gripman
ironman936612ironman
plowman1444932plowman
potman102813572p_otman
preman104117452pr_eman
preplan1149952preplan
prolan8414692pro_lan
propane112716152prop_ane
protean92412192protean
rodman949712_rodman
roman75424822_ro_man
shopman14247262shopman
aroma71220143aro_ma_
aromas81018613aro_mas
bookman15136483bookman
bowman13129853_bowman
brogan9311043bro_gan
bromal10313653bro_mal
bromin102615693bro_min
chapman1637893chapman
corpsman1445133corpsman
cowman13910373_cowman
crewman1435753crewman
cropland1346303cropland
dolman95312403_dolman
doorman1037063doorman
drayman1335433drayman
dromon939363dro_mon
foeman11311233_foeman
footman1236403footman
foreman12312363foreman
freeman1237343freeman
frogmen1335893frogmen
frontman1344303frontman
frypan1434543fryp_an
goodman1135933goodman
gripmen1235033gripmen
groan65618423gro__an
ironmen936453ironmen
nonman8412363_nonman
orphan1137733or_phan
packman1736693packman
pampean1335543pampean
patrolman1343723patrolman
penman10312323p_enman
pikeman1535523pikeman
pitman102412123p_itman
pivotman1542053pivotman
plowmen1434883plowmen
pompano1345203p_ompano
pompon1238943p_ompon
popgun1145733p_opgun
poplar103611113p_oplar
poplin10413483p_oplin
poppa8409893p_oppa_
poppas93710713p_oppas
postman112410043postman
potmen102713093p_otmen
prehuman1545033prehuman
premen105017803pr_emen
prepay13310313prep_ay
preplans1249613preplans
preplant12712913preplant
pressman1247153pressman
priapean1243373priapean
prima95019343pr_ima_
primal104014623pr_imal
primas104418103pr_imas
proa66229963pro__a_
proas75028803pro__as
proband122710243pro_band
probang12278383pro_bang
prochain1548483prochain
proem94818273proem__
proemial1249183proemial
proems104711163proem_s
profane122111863pro_fane
program12311693program
progun968783pro_gun
prolamin12139753prolamin
prolans9314273pro_lans
prom87631703pro_m__
promine112819443pro_mine
promo95620003pro_m_o
promos105116423pro_mos
prompt12313013pro_mpt
prompts1337473prompts
proms95426413pro_m_s
pronoun939033pronoun
prop85932813prop___
propanes122415823prop_anes
propel103714063prop_el
propels113412843propels
propend123311273propend
propene112716043propene
proper104319953prop_er
propers113619033propers
prophage1649433prophage
prophase15410243prophase
prophet14316033prophet
propine113020213propine
propjet1839913propjet
propone112716303propone
proposal1247743proposal
propose112714843propose
propound1346393propound
propped113311953propped
propping122811673propping
propria1149933propria
props95726883prop__s
propyl13358183prop_yl
propyla14296633propyla
propylon1544873propylon
propyls14308193propyls
prosimian1366003prosimian
prosoma11310223prosoma_
prosomal1248543prosomal
prosomas1249723prosomas
protamin121210543protamin
protea82214763protea_
proteans102811543proteans
proteas92015123proteas
protein92414733protein
proton84318893pro_ton
proven114314773pro_ven
prowar114110943pro_war
proximal1945183proximal
ptomain1146963pto_main
pullman1135403pullman
ragman94013713_ragman
reman75730153_r_eman
replan83215823_replan
roan47234203_ro__an
rodmen939713_rodmen
rodsman1036653_rodsman
romano84912943_ro_mano
romans84620243_ro_mans
rowan85418733_ro_wan
shipman14247133shipman
shopmen14277203shopmen
showman15257293showman
snowman12226623snowman
socman1039813_socman
soman75024903_so_man
teopan839353teop_an
toman75724053_to_man
trapan82412973trap_an
trepan82511673trep_an
triptan947543triptan
tropin83316753trop_in
utopian9126273utopian
woman105818003_wo_man
woodman1336313woodman
woolman1235433woolman
workman1635613workman
yeoman1138823yeo_man

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.423422437.4
2DLD Change Limit1340271597.04619021.7
3Display Results1591590.0463456.5
 (SQL Overall)1786911597.51523777.9
 
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.