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

86 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
forfends154483(None) 
forefends1644491forefends
forfend1435411forfend_
forefend1545602forefend_
forfeits1445802forfeits
forfended1743742forfended
friends11396742f_riends
offends14234292_offends
portends11358962portends
bartends1136793bartends
bookends15374853bookends
boreens9310403boreen_s
commends15308463commends
compends15378253compends
contends112810573contends
defends12358773_defends
faciends1443573faciends
farfels13348213farfe_ls
fends96324973___fends
ferments13311473ferments
fiends104110293f__iends
foments122912053fo_ments
fonds95824823fo___nds
foramens1337823foramen_s
forbears1337073forbears
forbids13268263for_bids
forced126316523force_d_
forceps14466983force_ps
forcers124215713force_rs
forces114422133force__s
forded115020393forde_d_
fords95328183for___ds
foredo10510823for_e_do
forefeels1593843forefeels
forefended1843243forefended
forehands1656743forehands
foreheads1647033foreheads
forelands1347173forelands
fores85847103for_e__s
forests104114953for_ests
forfeit1339203forfe_it
forfending1844183forfending
forged115519323forge_d_
forgers115218183forge_rs
forges105024263forge__s
forgets113813793forge_ts
forgings13287703forgings
forints10411833for_ints
forked145217143forke_d_
forkers144615783forke_rs
formants13269953formants
formed125021173forme_d_
formers128217953forme_rs
formes114623713forme__s
fornent10312933fornen_t
fortes95327183forte__s
fortunes1158283fortunes
forwards1537043forwards
forwent13310533forwen_t
forzandi2143043forzandi
forzando2142763forzando
forzandos2242553forzandos
founds104814193fo__unds
friend10388933f_riend_
fronds106412343f_r_onds
godsends11113353godsends
gorhens1137183gorhen_s
gormands1266563gormands
mordents1138813mordents
moreens939963moreen_s
morgens10310463morgen_s
norlands936443norlands
offend13365663_offend_
oreads73915773_or_eads
orients7311583_orients
perpends13227733perpends
portend103411193portend_
portents103512823portents
propends13249173propends
protends113010353protends
rends65129953__r_ends
sorbents10279123sorbents
torments10310453torments
torrents838143torrents
trends75513543_tr_ends
worsens104610263worsen_s

Search took 10 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 Limit146162869.47015434.2
3Display Results86860.0302866.7
 (SQL Overall)178691869.67318473.2
 
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.