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

88 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
foretimes144745(None) 
foretime1348211foretime_
aforetime1444042aforetime_
forelimbs1642232forelimbs
forenames1447542forenames
foresides1339702foresides
forties104323862for_ti_es
retimes95020172__retimes
sometimes1345992sometimes
zonetimes2044202zonetimes
aftertimes1544733aftertimes
airtimes1037503air_times
beforetime1751583beforetime_
betimes115114413__betimes
cortices12615013cor_tices
downtimes1544513downtimes
ferities111416713feriti_es
firesides1346603firesides
flextimes2142613flextimes
foetuses1136083fo_etuses
footies103721543fo_oti_es
forcipes1535943for_cipes
forearmed1544863forearmed
forearms1336603forearm_s
forebodes1547613forebodes
foredates13310053foredates
foredoes12310803fore_does
forefaces1747133forefaces
foregoes1239523fore_goes
forelimb1544083forelim_b
foremen12412923fore__men
foremilks1842783foremilks
forename1347853forename_
forenamed1545163forenamed
foresees11311643fore_sees
foreside12310303foreside_
forestages1446733forestages
forestries1348553forestries
foretastes1375593foretastes
foretells1245633foretells
foretoken1644353foretoken
foretokens1742833foretokens
foretopmen1752383foretopmen
foretops13137483foret_ops
forewings1645113forewings
forewomen1746463forewomen
forgeries13310003forgeri_es
forgetive16124463forgetive_
forgives1535753for_gives
formatives1846213formatives
formes114623713for___mes
fornices1369103for_nices
fortes95327183for_t__es
fortifies1548693for_tifies
fortis95418613for_ti__s
fortunes1158283for_tunes
fouettes1137883fouet_tes
furmeties1446573furmeti_es
lifetimes1444153lifetimes
moieties10311263moieti_es
monetises11311043monetises
monetizes2049263monetizes
mortices12711563mor_tices
mortises10713613mor_tises
noontimes1164513noontimes
oftentimes1542633oftentimes
ofttimes1343123_ofttimes
onetime937623_onetime_
optimes1148473_o_ptimes
oreides8312023_ore_ides
overtimes141511303_overtimes
poetises10313953po_etises
poetizes19310253po_etizes
regimes104514743__regimes
reties65436193__reti_es
retiles74426993__retiles
retime85321803__retime_
retimed104714653__retimed
retines75134673__retines
retires74726213__retires
sometime1246753sometime_
sorties74126403sor_ti_es
sureties8316583sureti_es
termtimes1354803termtimes
unretires945933unretires
vortices1369123vor_tices
wartimes1336963war_times
zonetime1944953zonetime_

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 Filter1786911486410.453394461.4
2DLD Change Limit148641887.97018650.1
3Display Results88880.0461913.0
 (SQL Overall)178691888.46921099.4
 
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.