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

70 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
attic7561835(None) 
antic75728861antic
attics84413281attics
acetic10314502acetic
acmic11312332acmic
actin74922552actin
amnic95516232amnic
anti45536362anti_
antick124814582antick
antics84621452antics
antis55033312antis
aortic8316612aortic
arctic10313502arctic
areic73219392areic
asdic83814092asdic
aspic95114732aspic
astatic9514192astatic
astir55517092astir
atactic11410082atactic
atavic11189292atavic
ataxic15169202ataxic
atelic8313702atelic
atomic104115602atomic
atonic83420472atonic
atopic103514142atopic
atretic9313922atretic
atria56022332atria
atrip75315742atrip
att35454652att__
attach11118392attach
attack12148152attack
attain6311752attain
attar56516692attar
attire62412382attire
attrit6315742attrit
atypic13337652atypic
aulic74420242aulic
auric74521722auric
azoic162912062azoic
azotic172711622azotic
battik1238092battik
cantic103920532cantic
cattie85221012cattie
ethic101511222ethic
etic66123952_etic
haptic13511882haptic
iatric8312152iatric
ictic9311792ictic
lactic10713492lactic
lattice938432lattice
lattin64316222lattin
lotic76420662lotic
lytic104513032lytic
mantic104120902mantic
mastic103119172mastic
mattin84416632mattin
nastic82915962nastic
ontic74418572ontic
optic93715182optic
otic66624812_otic
otitic83112682otitic
pattie84020962pattie
ptotic102713362ptotic
static83118672static
stoic7317242stoic
tactic10612752tactic
tattie64817512tattie
tic56343462__tic
vatic10316422vatic
yttric1145432yttric

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 Filter178691538000.0931921408.6
2DLD Change Limit53800702.84618903.7
3Display Results70700.0461521.7
 (SQL Overall)178691702.98559863.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.