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 “fronts” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
fronts9441579(None) 
fonts86124751f_onts
fronds106412341fronds
frons86124041fron_s
front85029221front_
frontes104214161frontes
frosts94214621frosts
affronts1444162affronts
aroints7313132aroints
aroynts1036632aroynts
bionts8612392bionts
brants85723052brants
brents84717272brents
broncs101611152broncs
brunts85215452brunts
crofts114910592crofts
crones84729242crones
droits74314312droits
drones75023432drones
faints94818782faints
feints94813872feints
flints95617452flints
floats96816252floats
flongs105010492flongs
flouts94315272flouts
fonds95824822f_onds
fons76943892f_on_s
font77143752f_ont_
foots85528282f_oots
forints10411832forints
forts86034452f_orts
founts94313382founts
francs114112192francs
franks134912732franks
frats86829672fr_ats
frets85523402fr_ets
frits86129102fr_its
fritts94613192fritts
frocks154111212frocks
froes86126692fro_es
frogs96220772fro_gs
frond95316342fron_d
frontal1038362frontal
frontals1146272frontals
fronted114011272fronted
fronter103611582fronter
fronton1037202fronton
frontons1136502frontons
frost84727832frost_
frosty124710632frosty
froth115919282fro_th
froths125411442froths
frowns126011392frowns
frows116623102fro_ws
frowst125512072frowst
frowsts13426102frowsts
fruits94512492fruits
grants73722472grants
groats74816652groats
grots65025852gro_ts
grouts75015612grouts
grunts75511852grunts
irones64724012irones
irons55324132iron_s
prints84320102prints
prongs94314482prongs
pronto8313992pronto
rants55935342_rants
refronts1137772refronts
rents55935182_rents
roots55933672_roots
rots46454092_ro_ts
routs57133412_routs
runts55927632_runts
tronas63816902tronas
trones65629282trones
trots56629942tro_ts
trouts66116632trouts
wonts87621542_wonts
wrongs10338932wrongs

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551802.36034979.2
3Display Results80800.0302666.7
 (SQL Overall)178691802.73365382.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.