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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
abase7602348(None) 
abas68642081abas_
abased96514991abased
abaser86414341abaser
abases85720771abases
abash106016511abash
abate76627841abate
abuse77119561abuse
base64847021_base
aas310975392a_as_
aba512850952aba__
abaca95118042abaca
abaci94718842abaci
aback134816172aback
abaft10318062abaft
abaka114313822abaka
abamp11310602abamp
abasers95311972abasers
abashed1357662abashed
abashes12510372abashes
abasia8712952abasia
abated95918452abated
abater85518122abater
abates85825032abates
abaya104413172abaya
abbas95918642abbas_
abbe87627192ab_be
abbes96723522abbes
abele76323252abele
abide86223712abide
ablate82219212ablate
ablaze17239832ablaze
able66340532ab_le
ables75935542ables
abode85518812abode
abos67734412abos_
above105414322above
abrade9313052abrade
abs59356072ab_s_
abused95614272abused
abuser85413682abuser
abuses85119102abuses
abye97921002ab_ye
abyes105518532abyes
abys97221882abys_
abysm12598142abysm
abyss10669462abyss
adage7414052adage
agape85614842agape
agas55938842agas_
agate66525152agate
agave95314032agave
agaze156113662agaze
alae45643752ala_e
alane56135612alane
alas46358122alas_
alate55340332alate
albas75925392albas_
amas67746292amas_
amass77119682amass
amaze166016602amaze
ambage11510602ambage
amuse75920832amuse
anas46649862anas_
anise55129702anise
ansae55720972ansae
apace94718382apace
apse67725382a_pse
arame75026622arame
arise56436432arise
arose55832082arose
arse46539272a_rse
aubade939222aubade
avast85519362avast
awake125014782awake
aware86420022aware
awash116613162awash
baas66844672baas_
baases85218012baases
babas96325732babas_
babe86835822_babe
bade75140882_bade
bake105637512_bake
bale66353842_bale
bane65250432_bane
bare65460522_bare
bas58681752_bas_
based85331582_based
baser74828922_baser
bases75644352_bases
bash915240162_bash
bask105131422_bask
bass66146782_bass
bast66362412_bast
baste74829982_baste
bate66552422_bate
bise66437102_bise
blase75524232blase
case65848082_case
cease75227652cease
chase105127122chase
debase94014472debase
diabase1037112diabase
ease45042332_ease
erase54925492erase
fease84824872fease
lase46148512_lase
lease55230262lease
lyase85512412lyase
obas65730932obas_
obese75212422obese
pase65346862_pase
pease75231112pease
phase104617212phase
prase76128752prase
rase46149982_rase
tease55428712tease
ukase9428492ukase
urase54624692urase
vase75629652_vase

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 Limit538001201.42037887.3
3Display Results1201200.0333636.4
 (SQL Overall)1786911201.749102167.5
 
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.