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

184 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
foreleg113774(None) 
forelegs1236611forelegs
foremen12412922foremen
foresee10414332foresee
forever1338952forever
bootleg10276633bootleg
boreen8314313bore_en
boweled132810693boweled
bowleg12369183bo_wleg
corbeled1338373corbeled
coreless103013833coreless
corselet10414573corselet
corslet9318063corslet
coruler9311713coruler
dogleg936323do_gleg
doweled12269773doweled
farle86929243far_le_
farles96025783far_les
fartlek1434493fartlek
feeler93215173f_eeler
ferreled1234843ferreled
ferule93413203ferule_
feruled11318423feruled
ferules103112723ferules
firebug1383793firebug
firedog1244473firedog
fireless112810593fireless
firelit10310863firelit
firemen1238773firemen
fireplug1442083fireplug
foaled104515963fo_aled
foemen11310523fo_emen
foible11410383foible_
foibles1238853foibles
foiled104618403fo_iled
foley115222303fo__ley
folles93820473fo_lles
fondle104412943fondle_
fondled12399423fondled
fondler11348883fondler
fondles113512613fondles
fooled104317823fo_oled
footle93914383footle_
footled113610763footled
footler104011873footler
footles103715713footles
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
forage104617003forage_
foraged124812283foraged
forager114412563forager
forages114217283forages
foramen12310533foramen
forayed14368593forayed
forayer13368953forayer
forbye14427883forbye_
force105324273for_ce_
forced126316523for_ced
forceless1435723forceless
forcer114917343for_cer
forces114422133for_ces
forcing134013753forcing
forded115020393for_ded
fording123717043fording
fordless12289003fordless
fordoes11311963fordoes
fore78351473for__e_
forearm1238703forearm
forebay1538133forebay
forebear1346383forebear
foreby1438633fore_by
forebye1536353forebye
foredeck1874353foredeck
foredid1238503foredid
foredo10510823fore_do
foredoes12310803foredoes
forefeel14105513forefeel
forefeet14129393forefeet
forefelt14117363forefelt
forefend1545603forefend
forego1038903fore_go
foregoer1237253foregoer
foregoes1239523foregoes
foregut1149163foregut
forehead1537893forehead
foreign1136833foreign
foreknew1843733foreknew
forelady1545073forelady
foreland1239013foreland
forelimb1544083forelimb
forelock1745593forelock
foreman12312363foreman
forepaw1595613forepaw
forepeak17134783forepeak
foreplay1645673foreplay
foreran10311793foreran
forerun1037653forerun
fores85847103for__es
foresaw1377133foresaw
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
forest94926743fore_st
forested12312463forested
forester11313673forester
forests104114953forests
foretell1146123foretell
foretop12117893foretop
forevers1438173forevers
forewent1439423forewent
forewing1539003forewing
forge95126943for_ge_
forged115519323for_ged
forger104820773for_ger
forges105024263for_ges
forget106326393for_get
forging124114723forging
forgoer1137693forgoer
forgoes11311353forgoes
forked145217143for_ked
forker134717903for_ker
forkier144311593forkier
forking154014843forking
forkless15267433forkless
forme105225993for_me_
formed125021173for_med
formee113919943for_mee
former114221403for_mer
formes114623713for_mes
forming133615733forming
formless13248083formless
forte86131463for_te_
fortes95327183for_tes
forties104323863forties
fouled104315973fo_uled
fouler93614903fo_uler
foureyed1543663foureyed
fourplex2042093fourplex
foveae1237563foveae_
foveole13106873foveole_
foveoles1496643foveoles
foveolet14107543foveolet
fowled133914103fo_wled
fowler123712583fo_wler
free75940183f_re_e_
freed95223543f_re_ed
freely12310963f_reely
freer86021243f_re_er
frees86131393f_re_es
frere85617723f_rere_
freres94716173f_reres
froglet11310063froglet
fueled104913603f_ueled
fueler94313933f_ueler
furled104717053fur_led
furler93616403fur_ler
hoveled14209293hoveled
modeled1139463modeled
modeler1039293modeler
morale85220553morale_
morales93619403morales
moreen8313343more_en
morel75729093morel__
morelle91210803morelle
morelles10710493morelles
morello9117793morello
morels84820023morel_s
morseled1147193morseled
omelet8317073_omelet
orle45630463_or_le_
orles55326213_or_les
proleg94612113_proleg
redleg839273__redleg
relet54749823__relet
repeg84015053__repeg
roweled11269863roweled
sorel56231443sorel__
sorels63921163sorel_s
sorely94618013sorel_y
toweled112410223toweled
yodeled1236863yodeled
yodeler1136343yodeler

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.470380193.6
2DLD Change Limit1340271847.34318252.3
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.87622688.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.