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

111 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
ironman93661(None) 
ironmen936451ironmen
frogman1335872frogman
frontman1344302frontman
ironwoman1453642ironwoman
nonman8412362_nonman
propman1339062propman
rodman949712_rodman
roman75424822_ro_man
aeonian738353aeonian
airman82414223air__man
airwoman1344673airwoman
aroma71220143aro_ma_
aromas81018613aro_mas
birdman1236673bir_dman
bondman1238043_bondman
bookman15136483bookman
bowman13129853_bowman
brogan9311043bro_gan
bromal10313653bro_mal
bromin102615693bro_min
cooncan1147233cooncan
cowman13910373_cowman
crewman1435753crewman
dolman95312403_dolman
doorman1037063doorman
drayman1335433drayman
dromon939363dro_mon
eonian6311833_eonian
fireman1249333fir_eman
firman112211343fir__man
foeman11311233_foeman
footman1236403footman
foreman12312363foreman
freeman1237343freeman
frogmen1335893frogmen
frontal1038363frontal
frontmen1344423frontmen
fronton1037203fronton
goodman1135933goodman
gripman1234463gripman
groan65618423gro__an
gunman9299453_gunman
honan85319773_hon_an
iceman1037853i_ceman
inhuman1265483inhuman
iron46728463iro___n
ironbark1443063ironbark
ironclad1143093ironclad
irone55126363iron__e
ironed74916013iron_ed
ironer64216453iron_er
ironers74813553ironers
irones64724013iron_es
ironic8313773iron_ic
ironical1049963ironical
ironies7517423ironies
ironing82414013ironing
ironist7314843ironist
ironize16610373ironize
irons55324133iron__s
ironware1144653ironware
ironwomen1443983ironwomen
irony85015903iron__y
kirkman1243773kir_kman
krona93611793kron_a_
kronen10348913kron_en
longan75612363_longan
nonfan948293_nonfan
nonmen8412833_nonmen
penman10312323_penman
pivotman1542053pivotman
plowman1444933plowman
potman102813573_potman
preman104117453pr_eman
prolan8414693pro_lan
pronoun939033pronoun
propmen1338763propmen
protean92412193protean
ragman94013713_ragman
randan7315253_randan
reman75730153_r_eman
roan47234203_ro__an
rodmen939713_rodmen
rodsman1036653_rodsman
romano84912943_ro_mano
romans84620243_ro_mans
ronion63315643_ronion
ronyon9309133_ronyon
rowan85418733_ro_wan
shopman14247263shopman
showman15257293showman
sirenian845783sirenian
snowman12226623snowman
socman1039813_socman
soman75024903_so_man
strongman1243743strongman
tinman82411143_tinman
toman75724053_to_man
tongman1037573_tongman
trainman1046233trainman
trona54118953tron_a_
tronas63816903tron_as
unman72715423__unman
vanman1139793_vanman
wireman1237843wir_eman
woman105818003_wo_man
woodman1336313woodman
woolman1235433woolman
workman1635613workman
yeoman1138823yeo_man

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 Limit1340271116.06322105.7
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.51527427.6
 
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.