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

118 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
agios6591986(None) 
adios65822861adios
agio57828451agio_
abos67734412a_bos
acids87121002acids
adagios945512adagios
adits66523712adits
ados57633512a_dos
aegis6316782aegi_s
agars66120642agars
agas55938842ag_as
agers65027852agers
ages55844592ag_es
aggies83515512aggies
aggros836552aggros
aghas97014872aghas
agile65122262agile
agin56132712agi_n
aging77026352aging
agings86312672agings
agism84614062agism
agisms9399392agisms
agist66325582agist
agists75713172agists
agita6315422agita
agitas7310592agitas
aglow94711972aglow
agmas85919872agmas
ago48845522ag_o_
agog68019002ag_og
agon56531882ag_on
agons66423782agons
agrias74315392agrias
ags47551662ag__s
agues64919052agues
ahis76135382ahi_s
aids57846362a_ids
ails45654712a_ils
aims67738182a_ims
ains46158882a_ins
airs46447422a_irs
ais39083572a_i_s
aits46355532a_its
algins74816432algins
alias55834602alias
alifs86121262alifs
aliyos9349532aliyos
altos55822952altos
ambos95321252ambos
amias75831472amias
amids85627512amids
amies76837692amies
amigos94511212amigos
amins75534322amins
amirs75924922amirs
amis66445322ami_s
amiss75823072amiss
ammos94815822ammos
amnios84912522amnios
anglos74413912anglos
anils56326722anils
anion55028812anion
anions64123032anions
anis45746462ani_s
apos65433822a_pos
argils75213622argils
arias55438022arias
arils58732202arils
ariose64818722ariose
ariosi64313032ariosi
arioso64312402arioso
arvos86015662arvos
askos95011772askos
audios72312282audios
autos56523322autos
avion84218342avion
avions94114392avions
aviso85713962aviso
avisos95410482avisos
avos77227012a_vos
axils127217502axils
axiom143913592axiom
axioms15408052axioms
axion1211316912axion
axions134713482axions
axis116127912axi_s
ayins85321612ayins
bagnios1036072bagnios
bigos85020012bigos
bios66335322_bios
brios74725722brios
dagos76419442dag_os
danios7314602danios
egis56520652egi_s
egos55821652eg_os
fagins10513862fagins
fugios1037582fugios
gains65729512gains
gaits65726012gaits
gibs75529272_gibs
gids65933742_gids
gies55641422_gies
gigs66631182_gigs
gins55543952_gins
gips75632922_gips
giros65722652_giros
gits55744592_gits
goos57644912_goos
gos47155132_g_os
magics115311612magics
olios54520852olios
patios85221782patios
radios74018672radios
ragis66325602ragi_s
ratios64922672ratios
sagos66123872sag_os
trios55528092trios
yagis95416572yagi_s

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.313570897.8
2DLD Change Limit538001181.47036598.6
3Display Results1181180.0303933.3
 (SQL Overall)1786911181.81398560.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.