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

100 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
anear5542032(None) 
anears63717181anears
near45236501_near
abeam9316532abeam
afar76720782a_far
afeard1058262afeard
agar58726412a_gar
ager55935842age_r
ahead96817052ahead
ajar116217702a_jar
alar46340072a_lar
alegar739282alegar
altar55520642altar
ameer75618982ameer
ana39559832an_a_
anal48037522an_al
anas46649862an_as
ane37866952ane__
aneared8512742aneared
anele55628832anele
anent54931842anent
anes45255932ane_s
anew76623132ane_w
anga56831352anga_
angary10311322angary
angas65827982angas
anger66225872anger
anlas55626932anlas
anna45529012anna_
annal56520762annal
annas55824882annas
anneal64812292anneal
anoa45634472anoa_
anoas57226492anoas
ansa45927772ansa_
ansae55720972ansae
anta46839582anta_
antae56828292antae
antas55432032antas
antbear935062antbear
antiar6317172antiar
antra56521922antra
apeak115513452apeak
aper66336232ape_r
apnea73413412apnea_
apneal83411122apneal
apneas83211382apneas
appear10379342appear
area45843392area_
areae55229742areae
areal55928732areal
areas55935772areas
arrear6310252arrear
asea46327182asea_
attar56516692attar
aurar54420252aurar
aver75931882ave_r
aweary1237302aweary
bear66844642_bear
blear75918682blear
caner75334772cane_r
clear76219052clear
dear55343602_dear
denar65223292denar
drear65016902drear
ear36867882__ear
endear74110012endear
fear75337792_fear
gear55934972_gear
gnar56021382gn_ar
hangar104114512hangar
hear76143882_hear
invar839512invar
kantar10311152kantar
knar85818722kn_ar
knead10429662knead
lear47045952_lear
linear65113342linear
navar83912732navar
neap66927012_neap
nears55529422_nears
neat46356782_neat
pear69745232_pear
rear45644552_rear
saner54334322sane_r
sangar73617682sangar
sansar63613392sansar
sear47353842_sear
shear85424832shear
smear74416392smear
sneak96016172sneak
sneap75514822sneap
sneer54919952sneer
spear75821062spear
swear85316852swear
tear45242882_tear
unbar71913612unbar
unbear889162unbear
wear75836722_wear
year76534252_year

Search took 2 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.296603685.8
2DLD Change Limit538001001.47036598.6
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.79699493.9
 
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.