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

140 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
alcaics113702(None) 
alcaic1039981alcaic_
alcades101011472alcades
alcaide1088452alcaide
alcaides11117672alcaides
alcids94812292alc_ids
arctics1138952arctics
laics76419252_l_aics
acacia10311353a_cacia
acacias11510403a_cacias
acarids105312243a_carids
acarus8312193a_carus
acclaims1444493acclaims
acids87121003a_c_ids
acmic11312333a_cmic_
actins86321103a_ctins
affairs1334163affairs
agarics10319943agarics
agnails837003agnails
alack114820063al_a_ck
alamos8415003al_amos
alands75418373al_ands
alanins7315803alanins
alans55636173al_a_ns
alants67722023al_ants
alarms85913053al_arms
alas46358123al_a__s
alates64833963al_ates
albas75925393alba__s
albatas938373albatas
alcade91111513alca_de
alcahest1345353alcahest
alcalde10104953alcalde
alcaldes11114983alcaldes
alcayde13103723alcayde
alcaydes14133723alcaydes
alcazar1843453alcazar
alcazars1942963alcazars
alcid85817973alc_i_d
alcoves1297873alcoves
aldrins8310203aldrins
alecs76620733al__ecs
alembics1442963alembics
alevins102110573alevins
alexias14249793alexias
alexins141910663alexins
alfakis1475073alfakis
alfas87219043alfa__s
algas65624933alga__s
algins74816433al_gins
alias55834603al__ias
aliases7914493aliases
alibies9313323alibies
alibis8311073alibi_s
alifs86121263al__ifs
alkalic13146973alkalic_
alkalies12158543alkalies
alkalis11148793alkalis
alkanes113812933alkanes
alkies104518093al_kies
allays94313743alla_ys
allies63827673al_lies
almahs118611613alma_hs
almanacs1254443almanacs
almas76629773alma__s
alnico877943al_nico
alnicos985533al_nicos
aloins65022203al_oins
alpaca1047383alpa_ca
alpacas1137073alpacas
altars64518153alta_rs
alumins9512983alumins
always12409133alwa_ys
antics84621453a_ntics
aphasics15257233aphasics
aquatics1945893aquatics
arcades101113193arcades
arcadias1149163arcadias
archaic1438823archaic_
archils12510533archils
arctic10313513arctic_
ascarids11438503ascarids
ascaris93613323ascaris
ascetics1247073ascetics
asdics9439863a_sdics
aspics104211563a_spics
assails769093assails
assais6711963assai_s
ataxics16196643ataxics
atomics113110853atomics
atonics93613713atonics
attains7310983attains
attics84413283a_ttics
avails939693a_vails
awaits96411953a_waits
baldrics13164893baldrics
blains84516373bl_ains
caids85226423__caids
cains75334303__cains
calcars11312653calca_rs
calcic9311873calc_ic_
calorics122810463calorics
calpacs133110343calpa_cs
calpains1239763calpains
chics123920943__chics
claims105211573cl_aims
clerics1149333clerics
clinics11338743clinics
clitics11279973clitics
cocains111313923cocains
dalmatics1445523dalmatics
eclairs935963eclairs
elains64919853el_ains
flails94313003fl_ails
flairs95711913fl_airs
flics105418363fl__ics
galyacs1335273galya_cs
glacis94012133glaci_s
glairs75211333gl_airs
kalpacs15327133kalpa_cs
lacs66942483_l_a_cs
lactic10713493lactic_
laic65931563_l_aic_
laich105920713_l_aich
laichs115110893_l_aichs
lairs55425873_l_airs
lanais6316793lanai_s
logics95711123_logics
lyrics11357943_lyrics
mosaics1138073mosaics
palais8420423pal_ai_s
picnics13297343picnics
plaice10311553pl_aice
plaices11411143pl_aices
plaids94312443pl_aids
plains85019593pl_ains
plaits83816473pl_aits
tactics1149323tactics
vocalics1545593vocalics
volcanics1643653volcanics

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.1561145455.1
2DLD Change Limit1340271406.79619721.5
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.99825534.6
 
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.