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

90 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
forfeits144580(None) 
forfeit1339201forfeit_
forests104114952for_ests
forfeited1643792forfeited
forfeiter1544162forfeiter
forfeiters1643782forfeiters
forfends1544832forfends
forgets113813792forge_ts
surfeits1146222surfeits
comfits14328743comf_its
conceits122813613conceits
confects153110873confects
confits122811423conf_its
corbeils12358073corbeils
corneitis1146483corneitis
cornets94820573corne_ts
corrects1259573corrects
corsets94819803corse_ts
corvets124715023corve_ts
farfels13348213farfe_ls
ferments13311473ferments
ferrets103111393ferre_ts
florets1039853flor_e_ts
floruits1145153flor_uits
fogfruits1671403fogfruits
foments122912053fo_ments
forbears1337073forbears
forbids13268263for_bids
forceps14466983force_ps
forcers124215713force_rs
forces114422133force__s
forefeels1593843forefeels
forefeet14129393forefeet_
forefelt14117363forefelt_
forefends1644493forefends
foreguts1245563foreguts
foreign1136833for_eign
fores85847103for_e__s
forest94926743for_est_
forfeiting1744133forfeiting
forfeiture1652043forfeiture
forfeitures1751933forfeitures
forfend1435413forfe_nd
forgeries13310003forgeries
forgers115218183forge_rs
forges105024263forge__s
forget106326393forge_t_
forints10411833for_ints
forkers144615783forke_rs
forkiest153812303forkiest
forklifts1941973forklifts
formants13269953formants
formats123113573for_mats
formers128217953forme_rs
formes114623713forme__s
fornent10312933fornent_
forrit91916623for_rit_
fortes95327183forte__s
forties104323863for_ties
fortieth1445173fortieth
fortieths1542783fortieths
fortis95418613for_ti_s
forts86034453for___ts
fortuity1465573fortuity
forwent13310533forwent_
frets85523403f_r_e_ts
frits86129103f_r__its
fruits94512493f_r_uits
funfests14253563funfests
gorgets94711783gorge_ts
hordeins1238323hordeins
hornets104113553horne_ts
mordents1138813mordents
orbits84211433_or_bits
orceins937743_orceins
orgeats838353_orgeats
orients7311583_orients
parfaits1346913parfaits
perfects15107353perfects
portents103512823portents
profits122911243prof_its
refits94017653__refits
soffits1335093so_ffits
sorbents10279123sorbents
sorbets93012503sorbe_ts
surfeit10310343surfeit_
torments10310453torments
torrents838143torrents
worrits10258683wor_rits
worsets105512843worse_ts

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162907.54619369.5
3Display Results90900.0332727.3
 (SQL Overall)178691907.75223051.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.