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 “foregut” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
foregut114916(None) 
foreguts1245561foreguts
forego1038902foreg_o
forerun1037652forerun
forest94926742fore_st
forgat104018582for_gat
forget106326392for_get
forgot104318132for_got
choregus1484213choregus
fadeout11410193fadeout
firebug1383793firebug
firelit10310863firelit
firepot1248733firepot
floret9321123flore__t
foetus958523fo_etus
foldout1149533foldout
foment113718303fome_nt
forage104617003forag_e
foraged124812283foraged
forager114412563forager
forages114217283forages
forceful1644603forceful
fore78351473fore___
forearm1238703forearm
forebay1538133forebay
foreby1438633fore_by
forebye1536353forebye
forecast1349763forecast
forecourt1445753forecourt
foredate12310913foredate
foredid1238503foredid
foredo10510823fore_do
forefeet14129393forefeet
forefelt14117363forefelt
forefoot1448153forefoot
foregoer1237253foregoer
foregoes1239523foregoes
foregone1238583foregone
foreign1136833foreign
foreleg1137743foreleg
foreman12312363foreman
foremast1348613foremast
foremen12412923foremen
foremost1348583foremost
forepart1349703forepart
forepast1348043forepast
forepaw1595613forepaw
foreran10311793foreran
foreruns1146623foreruns
fores85847103fore__s
foresaw1377133foresaw
foresee10414333foresee
foresight1645323foresight
forests104114953forests
foretop12117893foretop
forever1338953forever
forewent1439423forewent
forfeit1339203forfeit
forge95126943for_g_e
forged115519323for_ged
forger104820773for_ger
forgers115218183forgers
forgery14419303forgery
forges105024263for_ges
forgets113813793forgets
forgo94418333for_g_o
forint9325023for_int
forkful1744773forkful
formant123416003formant
format113021353for_mat
formful1545183formful
fornent10312933fornent
forrit91916623for_rit
fort76456443for___t
forum108318763for__um
forwent13310533forwent
fought135112393fo_ught
freest95318283f_reest
freight1447603f_reight
frenum1188803f_renum
fret75845043f_re__t
fright133715243f_right
gorget87123863gor_get
morgue938113mor_gue
orgeat7515033_orgeat
precut102016533_precut
rebut75927383__rebut
recut74729243__recut
rotgut738793ro_tgut
sorest65028003sore_st
workout1448393workout

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.420425454.8
2DLD Change Limit134027916.05022153.2
3Display Results91910.0303033.3
 (SQL Overall)178691916.50027490.9
 
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.