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

77 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
account1110904(None) 
accounts1285841accounts
accent105116262acc_ent
accost101112262acco_st
accounted1444822accounted
amount8414482a_mount
count74932052__count
recount9315172recount
abound9239863a_bound
about75229083a_bou_t
accents113511233acc_ents
accept123210633acc_ept
accident13148183accident
accord1178843acco_rd
accordant1445353accordant
accords1247243accords
accosts11107993accosts
accountant1453543accountant
accounting1544923accounting
accouter1245363accouter
accoutre1244203accoutre
accrual1144553accrual
accrue1035823accru_e
accrued1233823accrued
accrues1135323accrues
accruing1344033accruing
accurst1146243accurst
accusant1246863accusant
accuse103411033acc_use
acorn75616623a_corn_
acorns85013013a_corns
acquit17610323a_cquit
acrobat11411813acrobat
acrodont1148123acrodont
adjoint15108283adjoint
adnoun757033adnoun_
adnouns835453adnouns
aground9216183aground
amounts937043a_mounts
ancient9514733ancient
ancon75718233anco_n_
ancone83916953anco_ne
anoint6423633a_noint
appoint11612483appoint
aroint6328153a_roint
around72712413a_round
aroynt9312893a_roynt
ascent84519653asc_ent
ascot76522513asco__t
astound845503astound
aunt46553653a___unt
avaunt959603a_vaunt
bacchant1747803bacchant
backcourt1944993backcourt
backout15612953backou_t
chaunt11613493_chaunt
clout75330463_clou_t
coconut11511473coconut
counts84618273__counts
county114313323__county
court75532773__court
cunt66243673__c_unt
demount1049743demount
discount11811313discount
fount84727033__fount
headcount1543583headcount
miscount1299473miscount
mount74128063__mount
occult1038433occ_ult
outcount1049143outcount
raccoon1176163raccoon_
raccoons1265453raccoons
recounts1038773recounts
remount9512283remount
scout75031453_scou_t
upcourt1146103upcourt
viscount1396783viscount

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027775.84322938.0
3Display Results77770.0302566.7
 (SQL Overall)178691776.27928458.5
 
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.