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 “trefoils” 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
trefoils114530(None) 
trefoil1066061trefoil_
preboils1267292preboils
reboils94111722_reboils
recoils93814872_recoils
reoils64516872_re_oils
tinfoils1144322tinfoils
trenails869842trenails
aerofoils1243393aerofoils
airfoils1144003airfoils
befools1236433_befools
befouls1236053_befouls
broils84114173br__oils
cresols939653creso_ls
foils85025813___foils
jetfoils1842453jetfoils
milfoils1343893milfoils
parafoils1445513parafoils
preboil1148953preboil_
precools1237703precools
prefile123413183pref_ile
prefiles133113443pref_iles
prefocus1544743prefocus
preforms1537413preforms
prevails1337673prevails
quatrefoils2351253quatrefoils
reboil83814683_reboil_
recoals94214633_recoals
recoil84016723_recoil_
recoins94019243_recoins
refalls103312243_refalls
refeels10379693_refeels
refels94618053_ref_els
refile95122373_ref_ile
refiles104122423_ref_iles
refill94514053_ref_ill
refills103711423_refills
refilm114311403_ref_ilm
refilms12347503_ref_ilms
refits94017663_ref_its
reflies104418533_reflies
refocus1236973_refocus
refold103812113_refo_ld
refolds11298953_refolds
reforms1239823_reforms
refries104419733_refries
refuels10399523_refuels
rejoins143111383_rejoins
remails94714563_remails
renails74917263_renails
reoil55321183_re_oil_
repolls939053_repolls
rerolls739943_rerolls
resails74616743_resails
retails74718973_retails
retools73411023_retools
roils54826793_r__oils
tenails73713923t_enails
tinfoil1044633tinfoil_
toenails847213toenails
toils54527493t___oils
tomfools1343543tomfools
topsoils1095143topsoils
traffics1644183traffics
trails64622513tr__ails
travails1146083travails
travois1037883travoi_s
treaties8316983treaties
treenails945563treenails
trellis739873trelli_s
tremolo946513tremo_lo
tremolos1046043tremolos
tremors93711233tremo_rs
trenail7410813trenail_
trendies9312213trendies
trendily1256443trendily
trendoids1143943trendoids
tressels8367653tressels
trifocals1444043trifocals
trifold1136243trifo_ld
triols66117803tr_io_ls
tripolis1038713tripolis
trochils1388583trochils
troilus736413tr__oilus
trois57226093tr__oi_s
trolls64613943tr__olls
trysails1144163trysails
turmoils1043983turmoils

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.403443402.0
2DLD Change Limit146162887.89318517.9
3Display Results88880.0302933.3
 (SQL Overall)178691888.32621461.8
 
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.