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

200 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
foreran1031179(None) 
foreman12312361foreman
forerank1546751forerank
forerun1037651forerun
fireman1249332fireman
firepan1236982firepan
foeman11311232fo_eman
forearm1238702forearm
forebay1538132forebay
forebrain1445162forebrain
forehand1537692forehand
foreign1136832foreign
foreland1239012foreland
foremen12412922foremen
forepaw1595612forepaw
foreranks1645292foreranks
foreruns1146622foreruns
foresaw1377132foresaw
forewarn14117172forewarn
moneran9311112moneran
reran57329102__reran
aforehand1642813aforehand
bodhran1343943bodhran
boreal84817213bore_al
boreas85421733bore_as
boreen8314313bore_en
borer75131273borer__
borers85122683borer_s
cateran9313773cateran
choreman15117603choreman
corban10314693cor_ban
coreign1037343coreign
corer75538873corer__
corers85231073corer_s
cornerman1345363cornerman
corral83616253cor_ral
curran8312023cur_ran
farer86733143farer__
farers95924053farer_s
federal1148533federal
feral85424653f__eral
fern76129323f__er_n
firearm1237203firearm
firebrand1544633firebrand
firebrat1348143firebrat
firefang1543923firefang
firemen1238773firemen
firepans1347153firepans
firer811229253firer__
firers94922683firer_s
firetrap1344863firetrap
firman112211343fir_man
foehn11236323fo_e_hn
foemen11310523fo_emen
foetal9311883fo_etal
footman1236403footman
fora75937393fo__ra_
foram105124933fo__ram
foramen12310533foramen
foray115023973fo__ray
forbad122710503for_bad
forbare122310513forbare
forbear1237523forbear
forbears1337073forbears
forcer114917343forcer__
forcers124215713forcer_s
fore78351473fore___
forearms1336603forearms
forebays1637263forebays
forebear1346383forebear
forebrains1544623forebrains
foreby1438633fore_by
forebye1536353forebye
forecast1349763forecast
foredate12310913foredate
foredid1238503foredid
foredo10510823fore_do
foredone1249733foredone
foreface1647113foreface
forefend1545603forefend
forefront1546493forefront
forego1038903fore_go
foregone1238583foregone
foregut1149163foregut
forehands1656743forehands
forehead1537893forehead
forelady1545073forelady
forelands1347173forelands
foreleg1137743foreleg
foremast1348613foremast
forename1347853forename
forenoon1146823forenoon
foreordain1452153foreordain
forepart1349703forepart
forepast1348043forepast
forepaws1695753forepaws
forepeak17134783forepeak
foreplay1645673foreplay
forereach1743663forereach
fores85847103fore__s
foresaid1247803foresaid
foresail1147823foresail
foresee10414333foresee
foreseen1139103foreseen
foreshank1944673foreshank
foreskin1547023foreskin
forest94926743fore_st
forestal11410283forestal
forestay1448193forestay
forests104114953forests
foretop12117893foretop
forever1338953forever
forewarns1585633forewarns
forewent1439423forewent
forewing1539003forewing
forewoman1744933forewoman
foreworn14108863foreworn
foreyard1546423foreyard
forgat104018583for_gat
forger104820773forger__
forgers115218183forger_s
forgery14419303forger_y
forker134717903forker__
forkers144615783forker_s
forlorn1096423forlorn
formal113215203for_mal
formant123416003for_mant
format113021353for_mat
former114221403former__
formerly1645003formerly
formers128217953former_s
forrit91916623for_rit
forward1438293forward
forworn13107793forworn
fovea11310483fove_a_
foveae1237563fove_ae
foveal1237703fove_al
foveas1238623fove_as
foyer116416553foyer__
foyers125413133foyer_s
freak125115243f_re_ak
freeman1237343freeman
frena85915273f_rena_
frere85617723f_rer_e
freres94716173f_reres
frogman1335873frogman
frypan1434543f_rypan
funeral1037623funeral
furan84320013f__uran
furfuran1463243furfuran
gomeral1038833gomeral
gorgerin1044963gorgerin
govern1036823gover_n
horseman1346823horseman
jordan1468063jor_dan
loran55925093lo__ran
loreal63814313lore_al
modern939523moder_n
monerans10310343monerans
moreen8313343more_en
morgan9311373mor_gan
ocean71212963_oce_an
opera7313573_opera_
operand1038003_operand
operant9317223_operant
operas8312453_operas
operon8811773_operon
oread64619603_ore_ad
oregano846253_oregano
orfray1234393_orfray
organ6915393_or_gan
origan7310693_origan
orphan1137733_orphan
orra46120723_or_ra_
outran63218893_outran
overman12311463_overman
overran10311663_overran
poriferan1443303poriferan
portray1237483portray
preman104117453_preman
redan66125013__redan
reman75730153__reman
rerun58722153__rerun
rewan85623663__rewan
sierran737193sierran
sokeman1337263sokeman
sorer56236593sorer__
sororal7310653sororal
sovran937153so_vran
sporran936743spor_ran
teleran7510173teleran
tolerant8411463tolerant
torero6313203torer_o
toreros7311343toreros
trepan82511673_trepan
veteran1039353veteran
wireman1237843wireman
womera11137593womera_
womeras1287593womeras
workman1635613workman

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 Limit1340272006.50020619.5
3Display Results2002000.0633174.6
 (SQL Overall)1786912006.96925640.8
 
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.