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

124 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
sadiron83604(None) 
sadirons936021sadirons
andiron848282andiron
hadron102913752had_ron
ladron73413322lad_ron
midiron1046002midiron
saffron1344172saffron
adios65822863_adi_os
adorn64917093_ador_n
airn46433833_a_ir_n
andirons948423andirons
anion55028813_ani_on
apron7318833_a_pron
aspirin937823aspirin
avion84218343_avi_on
axion1211316913_axi_on
bairn77515533ba_ir_n
baron78131243ba__ron
basion84315853basi_on
cairn75717513ca_ir_n
caldron1038153caldron
camion103917193cami_on
carrion9312673carrion
cation83925503cati_on
dacron94310693da_cron
daikon11217243da_ikon
daimon9259713da_imon
diuron738573__diuron
environ1044763environ
fanion94514323fani_on
flatiron1144623flatiron
gabion93211033gabi_on
gadroon938173gadroon
garron73113493ga_rron
giron66118993__giron
gridiron1072513gridiron
hadrons113314303had_rons
iron46728463___iron
kation104315683kati_on
ladino73615123ladino_
ladinos8389963ladinos
ladrone83611873lad_rone
ladrons83813193lad_rons
macron103615673ma_cron
madrona10288703mad_rona
madrone102812663mad_rone
madrono10288743mad_rono
maduro936983maduro_
maduros1036303maduros
madzoon1996063madzoon
malison939693malison
marron83717543ma_rron
matron83918313ma_tron
midirons1145883midirons
nadir61012973nadir__
nadiral836343nadiral
nadirs7109003nadir_s
nasion63914083nasi_on
nation64322803nati_on
natron64116023na_tron
noniron738373noniron
padrone102512073pad_rone
padroni10278613pad_roni
patron84018043pa_tron
radian74117273radi_an
radio64922493radi_o_
radios74018673radi_os
radon64620503rad__on
ration64226013rati_on
sabaton937713sabaton
sabayon1244233sabayon
sabin74924953sabi__n
sabir75917003sabir__
sabirs85414633sabir_s
sacaton938993sacaton
sadden83212403sad_den
sadi55834643sadi___
sadis64930853sadi__s
sadism94113493sadi_sm
sadisms10359113sadisms
sadist74221353sadi_st
sadists83310853sadists
saffrons1444303saffrons
safrol937283sa_frol
sailor63113753sa_ilor
saimin8313663sa_imin
sain45551293sa_i__n
salicin9311223salicin
salmon84614183sa_lmon
salon55228553sa__lon
saloon64418023sa_loon
samisen937673samisen
saran53730303sa__ran
sarin55239253sa__rin
sarod65325873sa__rod
sarong73914873sa__rong
saros55238063sa__ros
sasin54626573sasi__n
satin55935223sati__n
satire63218003satir_e
satires72617573satires
satiric939253satiric
saurian739913saurian
savarin10310003savarin
savin84625083savi__n
savior9710173savi_or
saviors1058993saviors
saxhorn1744223saxhorn
scion72214993s_ci_on
sedition939333sedition
shairn9269063shair_n
silicon9117533silicon
siren54525823s__iren
solion6616383soli_on
soliton7410233soliton
squadron1843503squad_ron
stasimon1042743stasimon
station72717243stati_on
suasion739363suasi_on
talion6317713tali_on
vidicon1343783vidicon
waitron1036333waitron
wanion93213063wani_on
warison1037083warison

Search took 9 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271248.20316338.8
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.67220605.5
 
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.