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

99 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
abides9471989(None) 
abide86223711abide_
abided105313311abided
abider95314461abider
abiders104011081abiders
abodes94417511abodes
aides65336601a_ides
amides95722661amides
asides75118871asides
azides165113801azides
bides85536771_bides
abases85720772abases
abates85825032abates
abbes96723522ab_bes
abeles84719392abeles
abioses9311492abioses
ables75935542ab_les
abode85518812abode_
aboded104912512aboded
aboves114512842aboves
abrades10312072abrades
abridges1245302abridges
abuses85119102abuses
abyes105518532ab_yes
acids87121002acid_s
aedes64625152a_edes
aide56045002a_ide_
aided75828932a_ided
aider65431132a_ider
aiders74524632a_iders
aids57846362a_id_s
albites9313202albites
alines65735222alines
amices105018012amices
amide86128482amide_
amids85627512amid_s
amies76837692ami_es
amines84727982amines
animes84719592animes
anises64826692anises
anodes74418762anodes
aphides134711202aphides
apices104916262apices
apsides103911302apsides
arider74717742arider
aridest8316142aridest
arises65233802arises
aside65122082aside_
aubades1038752aubades
axises134413992axises
axites134913832axites
azide155617162azide_
azines155517072azines
babies106123652babi_es
baizes174315052baizes
bardes95026932bardes
bices95029962_bices
bide76041502_bide_
bided95424962_bided
bider85728372_bider
biders94822802_biders
bidet84935622_bidet
bidets95215532_bidets
bidis86721142_bidis
bids75838452_bid_s
bikes117529472_bikes
biles75542142_biles
bines76946792_bines
bises75435622_bises
bites75641172_bites
bizes165923662_bizes
bodes84935102_bodes
brides94423512brides
carbides133111692carbides
chides124620472chides
elides74420692elides
gabies93820732gabi_es
glides84518862glides
grides84422362grides
guides84118282guides
halides113416662halides
hides95129422_hides
ibices10398162ibices
ibidem1134792ibidem
ibises83610542ibises
ides57734232__ides
imides94515342imides
irides74519122irides
lapides103012042lapides
nides65229132_nides
oxides14109692oxides
prides94324182prides
rabies85226022rabi_es
rides66140812_rides
sabines94318482sabines
sides65838362_sides
slides73922182slides
tides64830152_tides
wides94832822_wides

Search took 3 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 Limit82551992.58031996.5
3Display Results99990.0303300.0
 (SQL Overall)178691992.95360511.7
 
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.