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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
avionics134495(None) 
avionic1237691avionic_
anionic9312872anionic_
aphonics15259522aphonics
atonics93613712a_tonics
avions94114392avion__s
bionics114310872_bionics
ionics84214482__ionics
ovonics12245552ov_onics
radionics1244392radionics
abiosis939373abiosi_s
abiotic11510463abiotic_
acinic104713543aci_nic_
acronic112814693acronic_
adonis7314063a_doni_s
aeonic83517043a_eonic_
aerobics1246833aerobics
agonic93515143a_gonic_
agonies83016623a_gonies
aiolis6316843a_ioli_s
alimonies1198333alimonies
aminic104413513ami_nic_
ammoniacs1553993ammoniacs
ammonias1247953ammonias
ammonic1349163ammonic_
amnionic1245603amnionic_
anions64123033anion__s
aphonias132611143aphonias
aphonic142713393aphonic_
armonica1276863armonica
armonicas13106123armonicas
arsenics1056763arsenics
astonies8815093astonies
atomics113110853a_tomics
atonias73315993a_tonias
atonic83420473a_tonic_
atonies75320953a_tonies
avianize2045723avianize
avianizes2145553avianizes
avians93711563avian__s
aviaries1139783aviaries
aviatic1239243aviatic_
avidins11349003avi_dins
avidness1246113avidness
avion84218343avion___
avoids104410203av_o_ids
axions134713483axion__s
axonic154312723a_xonic_
azonic175513153a_zonic_
bionic103614573_bionic_
biopics13318543_biopics
biotics113812173_biotics
brionies10310543brionies
cationic12310013cationic_
chronics1538683chronics
clinics11338743cli_nics
colonics123711613colonics
conics103920593__conics
cryonics1555413cryonics
ebonics1137193_ebonics
harmonics16107403harmonics
hedonics1445903hedonics
ionic74622663__ionic_
miotics112710653_miotics
ovonic11288183ov_onic_
phonics143110723_phonics
picnics13297343_picnics
pionic103515953_pionic_
raviolis1146103ravioli_s
sonics84315633__sonics
thionic1238893thionic_
thionins1177923thionins
tonics83617863__tonics
valonias1147473valonias
vinic10314973_vi_nic_
violins10311453_violins
vitrics12198553_vitrics

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit146162777.36019859.0
3Display Results77770.0302566.7
 (SQL Overall)178691777.79622920.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.