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

134 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
alkalis1114878(None) 
alkali10127551alkali_
alkalic13146961alkalic
alkalies12158541alkalies
alkalin11178171alkalin
alkalise12178041alkalise
alfakis1475072alfakis
alkalify1842822alkalify
alkaline12168282alkaline
alkalised14155262alkalised
alkalises13167482alkalises
alkalize21177632alkalize
alkalizes22157352alkalizes
alkaloid1345282alkaloid
alkaloids1443972alkaloids
alkalosis13124152alkalosis
alkanes113812932alkanes
alkylic16174232alkylic
alkyls13465722alkyl_s
argalis84214182argalis
aalii5316123a__alii
aaliis6312893a__aliis
aals49941143a__al_s
abatis84317933a_batis
agnails837003agnails
aiolis6316843a_iolis
akelas10311193a_kelas
alamos8415003al_amos
alands75418373al_ands
alanin6317273al_anin
alanins7315803al_anins
alans55636173al_a_ns
alants67722023al_ants
alarms85913053al_arms
alas46358123al_a__s
alates64833963al_ates
albas75925393alba__s
albatas938373albatas
alcades101011473alcades
alcaic1039983alca_ic
alcaics1137023alcaics
alcalde10104953alcalde
alcaldes11114983alcaldes
aldols7109713aldol_s
alfaki1385383alfaki_
alfalfa1342443alfalfa
alfalfas1441953alfalfas
alfaquis2092233alfaquis
alfas87219043alfa__s
algal66518213algal__
algas65624933alga__s
alias55834603alia__s
aliases7914493aliases
alibis8311073al_ibis
alkahest1554023alkahest
alkalifies1743233alkalifies
alkalising1545003alkalising
alkalized23146603alkalized
alkalizer22155563alkalizer
alkalizers23153953alkalizers
alkaloses13144853alkaloses
alkalotic1544013alkalotic
alkane104313323alka_ne
alkanet113714433alkanet
alkanets12366233alkanets
alkenes114212753alkenes
alkie95520033alk__ie
alkies104518093alk_ies
alkines114415733alkines
alkyds14404363alk_yds
alkyl12518043alkyl__
alkynes14336463alkynes
allays94313743alla_ys
alleles73812033alleles
allelic9118173allelic
allelism1046973allelism
allies63827673al__lies
alls46740923al__l_s
allylic12155843allylic
allyls9437273allyl_s
almahs118611613alma_hs
almas76629773alma__s
alpacas1137073alpacas
altars64518153alta_rs
always12409133alwa_ys
ambaris113112123ambaris
ankles104818383ank_les
annalist8413753annalist
annals66415923annal_s
antalkalis1452413antalkalis
appalls11337743appalls
appals104812943appal_s
arbalist10313333arbalist
argalas84011083argalas
argali75013743argali_
argals75517703argal_s
ascaris93613323ascaris
askesis1136123askesis
assails769093assails
assais6711963assa_is
avails939693a_vails
bialis83617163_bialis
bubalis11359903bubalis
dalasis8810533dal_asis
falbalas1345473falbalas
fallals103310193fallal_s
finalis103313643finalis
flails94313003fl_ails
flokatis1543123flokatis
glacis94012133gl_acis
halalas104214083hal_alas
halals95018313hal_al_s
jackals2036893jackal_s
kadis105921063__kadis
kails95525213__kails
kakis86116843__kakis
kales95730983__kales
kalif125021353__kalif
kalifs134410983__kalifs
lalls55324133_l_alls
lanais6316793lana_is
lapis76223153_l_apis
laris54737463_l_aris
lazulis1634903lazulis
okapis1235393_okapis
ooralis7312553ooralis
oxalis1339223_oxalis
palais8420423pal_a_is
salals65120083sal_al_s
salamis9313513sal_amis
skalds11437833_skalds
tallis63319963tal__lis
uakaris1146633uakaris
zaikais2042913zaika_is

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 Filter1786911340270.186960704.3
2DLD Change Limit1340271347.04619021.7
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.27824552.2
 
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.