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

56 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
acuter8441286(None) 
acute74720361acute_
acutes83917721acutes
cuter74728231_cuter
abater85518122abater
abuser85413682abuser
abutter957512abutter
accouter1245362accouter
accuser11347932accuser
achier113914262achier
acted88521732ac_ted
actor71116072ac_tor
acuate8315632acuate_
aculei839792aculei
acumen1049012acumen
acutely1246122acutely
acutest94410602acutest
after85719792a_fter
alter54828502a_lter
amuser84712622amuser
apter76120202a_pter
aster55434892a_ster
auger64922472a_uger
auteur6107942a_uteur
canter85230112canter
carter84932272carter
caster85232572caster
cater74840722_cater
causer84117782causer
cautery12349592cautery
citer74827332_citer
couter84930222couter
cuber95222532_cuber
curer75030752_curer
curter85320082_curter
cute66440452_cute_
cutes79438322_cutes
cutey105819792_cutey
cutler84718032_cutler
cutter84521002_cutter
fluter95316862fluter
muter74525542_muter
neuter63713792neuter
outer55633302_outer
pouter83923982pouter
router65025842router
saluter73512452saluter
scoter83815482scoter
scouter93313322scouter
scute75520942scute_
scutes85219192scutes
scutter93512172scutter
souter64225922souter
tauter64318022tauter
touter63821032touter
yachter1534912yachter

Search took 4 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 Limit82551562.69030688.1
3Display Results56560.0134307.7
 (SQL Overall)178691563.04658664.1
 
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.