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

126 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
adios6582286(None) 
adits66523711adits
ados57633511ad_os
agios65919861agios
audios72312281audios
radios74018671radios
abos67734412a_bos
acids87121012acids
adagios945512adagios
adds67622462ad_ds
adieu6417422adieu
adieus739632adieus
adipose1036652adipose
adipous1037182adipous
adit56443662adi_t
admits9411412admits
ado49146882ad_o_
adobos9438452adobos
ads49755742ad__s
adzes155913802adzes
agio57828452agio_
ahis76135382ahi_s
aides65336612aides
aids57846372a_ids
ails45654722a_ils
aims67738192a_ims
ains46158892a_ins
airs46447432a_irs
ais39083582a_i_s
aits46355542a_its
alias55834602alias
alifs86121262alifs
aliyos9349532aliyos
altos55822952altos
ambos95321252ambos
amias75831472amias
amids85627522amids
amies76837692amies
amigos94511212amigos
amins75534322amins
amirs75924922amirs
amis66445322ami_s
amiss75823072amiss
ammos94815822ammos
amnios84912522amnios
andros7313302andros
anils56326722anils
anion55028812anion
anions64123032anions
anis45746472ani_s
apos65433822a_pos
arias55438032arias
arils58732202arils
ariose64818722ariose
ariosi64313032ariosi
arioso64312402arioso
arvos86015662arvos
asdics9439862asdics
askos95011772askos
audio62917102audio_
audits72814112audits
autos56523322autos
avion84218342avion
avions94114392avions
aviso85713962aviso
avisos95410482avisos
avos77227012a_vos
axils127217502axils
axiom143913592axiom
axioms15408052axioms
axion1211316912axion
axions134713482axions
axis116127912axi_s
ayins85321612ayins
bios66335332_bios
brios74725722brios
cadis84428502cadi_s
dados75522432dados
dagos76419442dagos
dais57040702dai_s
danios7314602danios
datos65222782datos
dibs76233692_dibs
didos76820822_didos
dies55653532_dies
difs86027332_difs
digs66036062_digs
dims75435032_dims
dinos65428062_dinos
dins56652052_dins
diol57329142_diol
diols65521012_diols
dips75536922_dips
dis46459902_di_s
diss56434492_diss
dits56450532_dits
dos48062312_d_os
duos56728132_duos
edits65819032edits
eidos65817762eidos
fados95620732fad_os
fidos95819062fidos
gadids95611822gadids
gadis74825292gadi_s
idiom899962idiom
idioms956412idioms
idiot6718862idiot
idiots768642idiots
kadis105921072kadi_s
ladies75124882ladies
ladinos8389962ladinos
lidos65219892lidos
nadirs7109002nadirs
odious749932odious
olios54520852olios
padis86227142padi_s
patios85221792patios
qadis155917852qadi_s
radio64922492radio_
radius73914872radius
ratios64922672ratios
sadis64930852sadi_s
trios55528092trios
udos56619902ud_os
wadies105121202wadies
wadis95223962wadi_s

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 Filter178691538000.310576422.6
2DLD Change Limit538001262.39322482.2
3Display Results1261260.0304200.0
 (SQL Overall)1786911262.73365382.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.