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

55 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
fourteen114450(None) 
fourteens1243341fourteens
fourteener1352332fourteener
fourteenth1651722fourteenth
boreen8314313bo_r_een
bourgeon1144683bourgeon
bourree91311343bourree_
bourrees10127643bourrees
bourtree10135573bourtree
bourtrees11154013bourtrees
burthen1236363_burthen
courted103514923court_ed
courter94516483court_er
courters103015373courters
courtesan1144173courtesan
courtesy1364973courtesy
courtezan2042983courtezan
courtier1059333courtier
fifteen1343923f_ifteen
footmen1246583fo_otmen
foramen12310533fo_ramen
foremen12412923fo_remen
foreseen1139103foreseen
formee113919943fo_rmee_
forte86131463fo_rt_e_
fortes95327183fo_rt_es
forties104323863fo_rties
fortune1068303fo_rtune
fouette1038213fouette_
fouettes1137883fouettes
foughten1544003foughten
fountain1144923fountain
fourchee1645383fourchee
foureyed1543663foureyed
fourgon1134863four_gon
fourpenny1761433fourpenny
fourplex2042093fourplex
fourteeners1452093fourteeners
fourteenths1751143fourteenths
fourth12357443fourt__h
fourthly1742523fourthly
fourths13374953fourt_hs
further1337003f_urther
moreen8313343mo_r_een
outseen72712333_outseen
posteen93512623po_steen
postteen1055693postteen
poteen83514263po__teen
potteen9319673po_tteen
routemen10105813rou_temen
subteen938523_subteen
thirteen1143303thirteen
torten65314353to_rt_en
tureen63312723_tur_een
youthen1336153you_then

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 Filter1786911461620.423422437.4
2DLD Change Limit146162557.92318447.8
3Display Results55550.0301833.3
 (SQL Overall)178691558.37621333.7
 
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.