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

254 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
foreman1231236(None) 
fireman1249331fireman
foeman11311231fo_eman
foremen12412921foremen
foreran10311791foreran
choreman15117602choreman
firemen1238772firemen
firepan1236982firepan
firman112211342fir_man
foemen11310522fo_emen
footman1236402footman
foramen12310532foramen
forebay1538132forebay
forehand1537692forehand
foreign1136832foreign
foreland1239012foreland
foremast1348612foremast
forepaw1595612forepaw
forerank1546752forerank
forerun1037652forerun
foresaw1377132foresaw
forewarn14117162forewarn
forewoman1744932forewoman
formal113215202for_mal
formant123416002for_mant
format113021352for_mat
freeman1237342freeman
frogman1335872frogman
horseman1346822horseman
preman104117452_preman
reman75730152__reman
sokeman1337262sokeman
wireman1237842wireman
workman1635612workman
aforehand1642813aforehand
airman82414223air_man
axeman1538103_axeman
bargeman1345143bargeman
barman103519703bar_man
baseman1138553baseman
bedeman12168843bedeman
birdman1236673birdman
boardman1344393boardman
boatman1147053boatman
bogeyman1643223bogeyman
bogyman1544933bogyman
bohemian1544763bohemian
bondman1238043bondman
bookman15136483bookman
boreal84817213bore_al
boreas85421733bore_as
boreen8314313bore_en
bowman13129853bo_wman
carman103920743car_man
caveman1437073caveman
choremen1597603choremen
corban10314693cor_ban
coreign1037343coreign
coremia11310363coremia
cornerman1345363cornerman
corpsman1445133corpsman
cowman13910373co_wman
crewman1435743_crewman
dolman95312403do_lman
doorman1037063doorman
dormant102814373dor_mant
dormin9312313dor_min
ferryman1643803ferryman
firefang1543923firefang
firemanic1653963firemanic
firepans1347153firepans
firmans12238523fir_mans
flagman13186173flagman
flyman14326423f_lyman
foehn11236323fo_e_hn
foetal9311883fo_etal
foilsman1353773foilsman
footmen1246583footmen
fora75937393for__a_
foram105124933for__am
foramens1337823foramens
foramina1346163foramina
forams115115913foram_s
foray115023973for__ay
forbad122710503for_bad
forbear1237523forbear
forcemeat1644253forcemeat
fore78351473fore___
forearm1238693forearm
forebays1637263forebays
forebear1346383forebear
forebrain1445163forebrain
foreby1438633fore_by
forebye1536353forebye
forecast1349763forecast
foredate12310913foredate
foredid1238503foredid
foredo10510823fore_do
foredone1249733foredone
foreface1647113foreface
forefend1545603forefend
forego1038903fore_go
foregone1238583foregone
foregut1149163foregut
forehands1656743forehands
forehead1537893forehead
forelady1545073forelady
forelands1347173forelands
foreleg1137743foreleg
foremasts1445793foremasts
foremilk1744373foremilk
foremost1348583foremost
forename1347853forename
forenoon1146823forenoon
forepart1349703forepart
forepast1348043forepast
forepaws1695753forepaws
forepeak17134783forepeak
foreplay1645673foreplay
foreranks1645293foreranks
foreruns1146623foreruns
fores85847103fore__s
foresaid1247803foresaid
foresail1147823foresail
foresee10414333foresee
foreseen1139103foreseen
foreshank1944673foreshank
foreskin1547023foreskin
forest94926743fore_st
forestal11410283forestal
forestay1448193forestay
forests104114953forests
foretop12117893foretop
foretopman1751683foretopman
forever1338953forever
forewarns1585633forewarns
forewent1439423forewent
forewing1539003forewing
forewomen1746463forewomen
foreworn14108853foreworn
foreyard1546423foreyard
forgat104018583for_gat
forlorn1096423forlorn
form95836873for_m__
formalin1347313for_malin
formals123312893for_mals
formants13269953for_mants
formate123115093for_mate
formats123113573for_mats
forme105225993for_m_e
formed125021173for_med
formee113919943for_mee
former114221403for_mer
formers128217953formers
formes114623713for_mes
formic13310453for_mic
forming133615733for_ming
formol112910333for_mol
forms105327053for_m_s
formyl14276443for_myl
forum108318763forum__
forums114611843forum_s
forworn13107783forworn
fovea11310483fove_a_
foveae1237563fove_ae
foveal1237703fove_al
foveas1238623fove_as
freak125115243f_re_ak
freedman1444143freedman
freemen1238463freemen
fremd115010323f_rem_d
frena85915273f_rena_
freshman1644623f_reshman
frogmen1335893frogmen
frontman1344303frontman
frypan1434543f_rypan
fugleman1442673fugleman
furan84320013fur__an
gateman1057463gateman
german9611983ger_man
gleeman1035363gleeman
goodman1135933goodman
gormand1157453gor_mand
herdman13238423herdman
horsemen1347483horsemen
hotelman1344103hotelman
houseman1346573houseman
iceman1037853_iceman
ironman936613ironman
jordan1468063jor_dan
juryman1943583juryman
kirkman1243773kirkman
korma115913073kor_ma_
kormas124511233kor_mas
leman75622603__leman
lineman939113lineman
loran55925093lor__an
loreal63814313lore_al
merman10513853mer_man
moneran9311113moneran
moneyman1545223moneyman
moreen8313343more_en
morgan9311373mor_gan
mortmain1244563mortmain
nobleman1244303nobleman
nonman8412363no_nman
normal83213533nor_mal
oarsman937733oarsman
ocean71212963_oce_an
oilman839483_oilman
oread64619603_ore_ad
oregano846253_oregano
organ6915393_or_gan
origan7310693_origan
orphan1137733_orphan
outman83115033_outman
overman12311463_overman
pikeman1535523pikeman
postman112410043postman
potman102813573po_tman
premen105017803_premen
propman1339063propman
redan66125013__redan
remain85919863__remain
remand95618963__remand
remans84823003__remans
remap95418103__remap
reran57329103__reran
rewan85623663__rewan
rodman949713ro_dman
rodsman1036653rodsman
roman75424823__roman
routeman10135493routeman
sideman1037973sideman
sockman1535663sockman
socman1039813so_cman
sokemen1337053sokemen
solemn838643solem_n
soman75024903so__man
surfman1236203surfman
swordman1443403swordman
teleman959573teleman
tollman935863tollman
toman75724053to__man
tongman1037553tongman
trepan82511673_trepan
turfman1243983turfman
verseman1345383verseman
wiremen1236903wiremen
woman105818003wo__man
woodman1336313woodman
woolman1235433woolman
workmen1635933workmen
yardman1335913yardman

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.1561145455.1
2DLD Change Limit1340272547.42018062.9
3Display Results2542540.0932731.2
 (SQL Overall)1786912547.66923300.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.