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

141 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
freeman123734(None) 
freedman1444141freedman
freemen1238461freemen
crewman1435752crewman
fireman1249332fireman
foeman11311232f_oeman
foreman12312362foreman
freedmen1444552freedmen
freehand1574992freehand
freemason1451872freemason
freeway1635602freeway
freshman1644622freshman
frogman1335872frogman
gleeman1035362gleeman
preman104117452pr_eman
reedman1037722_reedman
reman75730152_r_eman
axeman1538103_axeman
bargeman1345143bargeman
baseman1138553baseman
bedeman12168843bedeman
bemean10410683_bemean
brakeman1644313brakeman
brechan1437223brechan
bregma1134963bregma_
caveman1437073caveman
creedal1037093creedal
crewmen1436383crewmen
deewan10267553_deewan
demean9510563_demean
desman9311693_desman
drayman1335433drayman
ferryman1643813ferryman
firemen1238773firemen
firepan1236983firepan
firman112211343f_irman
flagman13186173flagman
flehmen1534913flehmen
flyman14326423f_lyman
foemen11310523f_oemen
footman1236403footman
foremen12412923foremen
foreran10311793foreran
forewoman1744933forewoman
fraena938063fraena_
freak125115243fr_e_ak
free75940183free___
freebase1344853freebase
freebee1238043freebee
freebie1236043freebie
freeborn1344803freeborn
freed95223543free__d
freedom1345863freedom
freedwoman1951753freedwoman
freeing113713913freeing
freelance1445143freelance
freeload1244733freeload
freely12310963free_ly
freemartin1551783freemartin
freemasons1551653freemasons
freer86021243free__r
freers94717303free_rs
frees86131393free__s
freesia1046323freesia
freesias1146333freesias
freest95318283free_st
freeware1446173freeware
freeways1744723freeways
freeze18349513free_ze
freezer19348523freezer
freezes193310353freezes
freezing21308323freezing
fremd115010323fr_em_d
frena85915273fr_ena_
freshen133010883freshen
freshmen1656023freshmen
fretsaw1343923fretsaw
frogmen1335893frogmen
frontman1344303frontman
frypan1434543fr_ypan
fugleman1442673fugleman
gateman1057473gateman
german9611983_german
gleemen1035723gleemen
green65522143gree__n
gripman1234463gripman
herdman13238423herdman
hetman112510603_hetman
horseman1346823horseman
iceman1037853_iceman
ironman936613ironman
kneepan1372623kneepan
legman949653_legman
leman75622603__leman
liegeman1143343liegeman
lineman939123lineman
merman10513863_merman
overman12311463overman
penman10312323_penman
pikeman1535523pikeman
preemie11310563preemie
preempt1337723preempt
preen75925053pree__n
prehuman1545033prehuman
premeal11310523premeal
premen105017803pr_emen
preplan1149953preplan
pressman1247153pressman
propman1339063propman
ragman94013713_ragman
rebegan1045953_rebegan
redan66125013_r_edan
redemand1245923_redemand
reearn6612143_reearn
reedmen1038333_reedmen
reemit8717223_reemit
regma84612333_regma_
reloan6415693_reloan
remain85919863_r_emain
remand95618963_r_emand
remans84823003_r_emans
remap95418103_r_emap
replan83215823_replan
reran57329103_r_eran
rewan85623663_r_ewan
rodman949713_rodman
roman75424823_r_oman
seaman84015903_seaman
seedman1037373seedman
sheepman1543853sheepman
sideman1037973sideman
sokeman1337263sokeman
teleman959573teleman
treelawn1142713treelawn
treen55622753tree__n
trepan82511673tr_epan
urethan1045473urethan
verseman1345383verseman
wheelman1642813wheelman
wireman1237843wireman
yeoman1138823_yeoman

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.403443402.0
2DLD Change Limit1340271415.78323176.0
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.23228673.1
 
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.