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

73 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
foregoers134595(None) 
foregoer1237251foregoer_
foregoes1239521foregoe_s
forgoers1236411for_goers
foragers12349632forag_ers
foreboders1644172foreboders
foredoes12310802foredoe_s
foreigners1444142foreigners
foreseers1237402foreseers
foresters12312542foresters
forevers1438172fore_vers
forgers115218182for_g_ers
forgoer1137692for_goer_
forgoes11311352for_goe_s
fairgoers1342013fairgoers
filmgoers1541983filmgoers
firepowers18122983firepowers
foetors1039763fo_eto_rs
foggers124112013fo__ggers
fomenters1437853fomenters
forager114412563forag_er_
forages114217283forag_e_s
forayers14277273for_ayers
forbearers1543673forbearers
forcers124215713for__cers
fordoes11311963for_doe_s
forebears1446413forebears
foreboder1545743foreboder_
forebodes1547613forebodes
forebooms1645333forebooms
forecourt1445753forecourt
forecourts1542603forecourts
foredooms1544793foredooms
forefeels1593843forefeels
foregathers1843223foregathers
forego1038903forego___
foregoing1455793foregoing
foregone1238583forego_ne
foreguts1245563foreg_uts
forehoofs1844983forehoofs
foreigner1344663foreigner_
forelegs1236613fore_legs
forelocks1844743forelocks
foremothers1953013foremothers
forenoons1245743forenoons
foreseer1139013foreseer_
foresees11311643fore_sees
foreshores16107403foreshores
forester11313673forester_
foreswears1643223foreswears
foretokens1742833foretokens
foretops13137483foreto_ps
forever1338953fore_ver_
foreword15118963forewo_rd
forewords16117403forewords
foreworn14108863forewo_rn
forfeiters1643783forfeiters
forger104820773for_g_er_
forgery14419303for_g_ery
forges105024263for_g_e_s
forgets113813793for_g_ets
forgetters1444163forgetters
forgivers1643713forgivers
forkers144615783for__kers
formers128217953for__mers
forsakers1644653forsakers
freers94717303f_re__ers
freezers20307173f_reezers
frescoers1454563f_rescoers
fretters113410303f_retters
gorgers94813643gor_g_ers
moviegoers1651193moviegoers
preggers12236833_preggers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641737.31020333.9
3Display Results73730.0332212.1
 (SQL Overall)178691737.76623009.4
 
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.