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

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

145 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
azygos193333(None) 
azygous2043121azygous
amigos94511212amigos
azygoses2163312azygoses
zygose19455552_zygose
abmhos1334973abmhos
abos67734413a__bos
abyes105518533aby_es
abys97221883aby__s
abysms13565653abysms
abyss10669463aby_ss
acyls104211523acy_ls
adages8412953adages
adagios945513adagios
adios65822863a_dios
adobos9438453adobos
ados57633513a__dos
aegis6316783a_egis
aerugos834923aerugos
agas55938843a__gas
ages55844593a__ges
aggros836543aggros
agios65919863a_gios
ago48845523a__go_
agog68019003a__gog
agon56531883a__gon
agons66423783a__gons
ags47551663a__g_s
ajugas1435263ajugas
alamos8415003alamos
algas65624933a_lgas
algor6513053a_lgor
algors7312553a_lgors
aligns75312953aligns
aliyos9349533aliyos
altos55822953a_ltos
ambos95321253a_mbos
amigas95912173amigas
amigo86515473amigo_
ammos94815823a_mmos
amnios84912523amnios
amylose1237193amylose
amyls104512693amy_ls
anchos114214893anchos
andros7313303andros
angas65827983a_ngas
anglos74413913anglos
anyhow1544103anyhow
anyon85615223any_on
anyons94513503anyons
apos65433823a__pos
argol65317263a_rgol
argols74514613a_rgols
argon65520593a_rgon
argons75018203a_rgons
argosy1036423a_rgosy
argot67728643a_rgot
argots74116023a_rgots
argus66716543a_rgus
arvos86015663a_rvos
aryls87015813ary_ls
askos95011773a_skos
audios72312283audios
autos56523323a_utos
avgas96912133a_vgas
avisos95410483avisos
avos77227013a__vos
ayahs116813523a_yahs
ayes76543513a_y_es
ayins85321613a_yins
ays67050293a_y__s
azans146516883az_ans
azides165113803azides
azido155411543azido_
azines155517073azines
azlon144312873az_lon
azlons154110423azlons
azo128233393az__o_
azoles154614613azoles
azon135725053az__on
azons146518253az_ons
azotes154312223azotes
azoths18366203azoths
azukis1963733azukis
azures15510183azures
bazoos173212623baz_oos
bigos85020013_bigos
bingos95514793bingos
bongos95316653bongos
boyos105418283boy_os
cargos94619183cargos
congos94219883congos
dagos76419443_dagos
dizygous2242193dizygous
egos55821653__egos
erugos7347343erugos
eryngos1142733eryngos
galagos938143galagos
gazabos1944453gazabos
gazebos1933493gazebos
gazoos163010223gaz_oos
gogos77516523_gogos
gos47155133___gos
gregos847533gregos
gyros95616483_gyros
hypos1312014743_hypos
imagos9117553imagos
jazzbos2442033jazzbos
kayos127714703kay_os
kazoos19259113kaz_oos
lanugos834453lanugos
largos74815063largos
latigos8277243latigos
logos67225333_logos
mangos94319333mangos
mayos105521933may_os
mongos94318623mongos
mungos94311373mungos
pargos95719043pargos
pengos94612413pengos
pingos95317673pingos
pyros105718293_pyros
sagos66123873_sagos
sargos74318273sargos
segos64919483_segos
sorgos74514663sorgos
tangos74216303tangos
toyos87519143toy_os
trigos74214173trigos
typos106015813_typos
tyros85118593_tyros
wazoos18288553waz_oos
zags146826683_zag_s
zayins18409713zayins
zeros144918103_zeros
zigs145422793_zig_s
zoos135828803_z_oos
zygoid2045943_zygoid
zygoma2143493_zygoma
zygomas2243413_zygomas
zygoses20436783_zygoses
zygosis20405953_zygosis
zygote19325483_zygote
zygotes20355163_zygotes
zymes1924712943_zymes

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161456.01618736.0
3Display Results1451450.0463152.2
 (SQL Overall)1786911456.20228811.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.