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

101 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
spearmen123485(None) 
spearman1244941spearman
seamen84518562s_ea_men
sonarmen1045252sonarmen
speared104314422spear_ed
spearer93913662spear_er
speargun1142732speargun
spearmint1365982spearmint
specimen1444422specimen
supermen12311302supe_rmen
barmen105418533__barmen
beadmen12299453_beadmen
carmen104019343__carmen
deadmen11248573_deadmen
germen9612313_ge_rmen
headmen13259513_headmen
hearken14338023_hearken
hearten102411753_hearten
leadmen10277903_leadmen
meatmen1138243_meatmen
mermen10813813_me_rmen
overmen12311803ove_rmen
peahen113410133_pea_hen
pearled10411543_pearled
pearler9310373_pearler
pearmain1245833_pearmain
pearter9412743_pearter
peasen84815963_pea_sen
penmen10311493_pe_nmen
permed115217343_pe_rmed
prearmed1397993prearmed
rearmed103912823_rearmed
repairmen1343333repairmen
sagamen10127503saga_men
salarymen1472683salarymen
sarment9318763s__arment
sarsen6314233s__arsen
seaman84015903s_ea_man
seamed94823883s_ea_med
seamer84223613s_ea_mer
seared75232843s_ear_ed
searer65432023s_ear_er
seedmen1037683s_eedmen
seedsmen1144303seedsmen
semen75724103s_e__men
sermon8413553s_e_rmon
sharpen12389723s_harpen
sheared114516003shear_ed
shearer104414683shear_er
sheepmen1544643sheepmen
smarten9348863s_marten
smeared104510623smear_ed
smearer94110403smear_er
smearier1036953smearier
sonarman1045563sonarman
spacemen1445413spacemen
spammed14348523sp_ammed
spammer133410433sp_ammer
spare75135563sp_ar_e_
spared95427493sp_ar_ed
sparer84524963sp_ar_er
spares84834553sp_ar_es
sparge94216053sp_arge_
sparged113512763sp_arged
sparger103613083sp_arger
sparges104016343sp_arges
sparked143513143sp_arked
sparker133914363sp_arker
sparred104512863sp_arred
sparse84516343sp_arse_
sparser94311483sp_arser
spartan948333sp_artan
spasmed12296993sp_asmed
speaker133311213spea_ker
spean74620513spea___n
speaned103411523spea_ned
spear75821063spear___
spearers103711143spearers
spearguns1242243spearguns
spearhead1542983spearhead
spearing113216103spearing
spearmints1443003spearmints
spears84019473spear__s
specimens1543403specimens
speered103614813speer_ed
speired103811103speir_ed
sperm93216013spe_rm__
spermic1338523spe_rmic
spermine12311433spe_rmine
sperms102512603spe_rm_s
stamen84115943s_ta_men
steamed103712143stea_med
steamer93313093stea_mer
stearin7312003stear_in
stearine8311903stearine
steersmen1143233steersmen
superman12310233supe_rman
swagmen1334973s_wagmen
swarmed1367483s_warmed
swarmer1247803s_warmer
swearer10349953swear_er

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 Limit1461621017.48319532.5
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.68523251.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.