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

145 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
foredid123850(None) 
fordid113512051for_did
foetid10510512fo_etid
forbid123312432for_bid
forded115020392for_ded
foredo10510822fored_o
foresaid1247802foresaid
foreside12310302foreside
redid74922392__redid
sordid83411162sor_did
aforesaid1343263aforesaid
bored85034303bore__d
boredom1236943boredom
choreoid1447923choreoid
coedit9316243co_edit
comedic14158633comedic
corded105923353cor_ded
cored85044223core__d
coremia11310363coremia
cormoid12310403cormoid
corvid12310473cor_vid
credit9315193_credit
faradic1337693faradic
farded114518953far_ded
fared95842343fare__d
felid94717173f__elid
fervid1337513fer_vid
fetid93715983f__etid
firebird1444633firebird
fired94829743fire__d
firedog1244473firedog
firelit10310863firelit
fireside1247013fireside
fjordic2042383fjor_dic
florid10311453flor__id
folded114212793fo_lded
fonded115717043fo_nded
foodie104413843fo_odie
foraged124812283foraged
forayed14368593forayed
forbad122710503for_bad
forbids13268263forbids
forboded15215353forboded
forced126316523for_ced
forcedly1744803forcedly
ford86835493for___d
fording123717043for_ding
fordo97218653for_d_o
fords95328183for_d_s
fore78351473fore___
forearm1238703forearm
forebay1538133forebay
forebode1448273forebode
foreboded1645673foreboded
forebody1745153forebody
foreby1438633fore_by
forebye1536353forebye
foredate12310913foredate
foredated1447683foredated
foredeck1874353foredeck
foredoes12310803foredoes
foredoing1456483foredoing
foredone1249733foredone
foredoom1445813foredoom
forefend1545603forefend
forego1038903fore_go
foregut1149163foregut
forehand1537693forehand
forehead1537893forehead
foreign1136833foreign
forelady1545073forelady
foreland1239013foreland
foreleg1137743foreleg
forelimb1544083forelimb
foreman12312363foreman
foremen12412923foremen
foremilk1744373foremilk
forensic1344943forensic
forepaw1595613forepaw
foreran10311793foreran
forerun1037653forerun
fores85847103fore__s
foresail1147823foresail
foresaw1377133foresaw
foresee10414333foresee
foresides1339713foresides
foreskin1547023foreskin
forest94926743fore_st
forested12312463forested
forests104114953forests
foretime1348213foretime
foretold1256493foretold
foretop12117893foretop
forever1338953forever
forewing1539003forewing
foreword15118963foreword
foreyard1546423foreyard
forfeit1339203forfeit
forfend1435413forfend
forfended1743743forfended
forged115519323for_ged
forked145217143for_ked
forkedly1944323forkedly
formed125021173for_med
formic13310453for_mic
fornix1636033for_nix
forrit91916623for_rit
fortis95418613for_tis
forward1438293forward
founded124011423founded
foureyed1543663foureyed
foxed165115213foxe__d
freed95223543f_re_ed
fremd115010323f_re_md
frigid1136923f_rigid
fronded12388863fronded
gored75227083gore__d
horded115420483hor_ded
hordein1138753hordein
horrid10311563hor_rid
iodid74315533io__did
lorded84916733lor_ded
morbid112511463mor_bid
nereid7312933nere_id
nordic939473nor_dic
orchid1289573_orchid
oread64619603_ore_ad
oreide7311673_oreide
outdid81210923_outdid
overdid12199173_overdid
pored85234513pore__d
prebid113512843_prebid
rebid85121363__rebid
redd66323183__red_d
reded74829123__reded
redia65524483__redia
redip87816963__redip
resid64124093__resid
sored66141783sore__d
toroid7416013tor_oid
torpid9310913tor_pid
torrid7311853tor_rid
trepid9310083_trepid
uredia73610063_uredia
worded114316623wor_ded

Search took 9 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.420425454.8
2DLD Change Limit1340271457.95616846.0
3Display Results1451450.0463152.2
 (SQL Overall)1786911458.42221217.2
 
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.