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

182 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
spacial113876(None) 
spatial9310321spatial
special11310301special
especial1246292especial
facial113615632_facial
glacial1038142glacial
racial83419242_racial
sacral83414412s_acral
social8813332s_ocial
spacially1645652spacially
spacier114011632spacier
spacing123614492spacing
spail74921552spa_i_l
spaniel948922spaniel
spathal1236262spathal
specials1238032specials
abaxial1646183abaxial
acacia10311353acacia_
acacias11510403acacias
adagial946373adagial
adaxial1545323adaxial
aecial84817313_aecial
apical10913903apic_al
asocial998653asocial
axial124515193__axial
biaxial1645363biaxial
bifacial15105273bifacial
biracial12107973biracial
brachial15219303brachial
coaxial16157003coaxial
cranial92114683cranial
crucial1157893crucial
eparchial1644403eparchial
epical10413393epic_al
epochal1445243epochal
espial839543esp__ial
facia103218463_facia_
faciae112913413_faciae
facials123310743_facials
facias113415803_facias
fascial1258303fascial
faucial1257323faucial
fecial114714623_fecial
fractal1237623fractal
gavial10310083_gavial
gharial1137343gharial
jacal14313703_jac_al
jackal1937613_jackal
labial84714343_labial
laical8312323_laical
narial6317953_narial
nasial6413283_nasial
opacify1743653opacify
opacity1436313opacity
optical1149863optical
ovarial1037613ovarial
paca85132243_pac_a_
pacas96029403_pac_as
pacha126518063_pacha_
pachas135017143_pachas
pacier105018683_pacier
pacify1667473_pacify
pacing114522753_pacing
paginal10269493_paginal
pail66141833_pa_i_l
paleal84716673_paleal
pallial92911253_pallial
palpal104112053_palpal
papal95820673_pa_pal
pariah114320583_pariah
parian83223963_parian
parral85517533_parral
partial92616263_partial
pascal10812373_pascal
paschal14157243_paschal
pausal81511963_pausal
penial84120893_penial
phial10313203_p_hial
pial65636703_p__ial
pical95524373_pic_al
plical10411683_plical
puparial1246313puparial
rachial122012173_rachial
radial74020393_radial
sabal75422483s_a_bal
sacra74516993s_acra_
sacrals93311793s_acrals
sahiwal1344443s_ahiwal
sail45447163s_a_i_l
salal55425703s_a_lal
sambal105215183s_ambal
samiel8313333s_amiel
sandal73317283s_andal
scandal1038673scandal
septical1259363septical
serial64625863s_erial
sharia93116733sharia_
shariah132210533shariah
sharias102516003sharias
sial45938833s___ial
snail57020203sna_i_l
socials999633s_ocials
space95325673spac__e
spaced114517253spac_ed
spaceman1445323spaceman
spacer104917793spac_er
spacers113813873spacers
spaces104722633spac_es
spacewalk2052463spacewalk
spacey136212533spac_ey
spaciest122310893spaciest
spacings13287043spacings
spacious1237813spacious
spackle15369573spackle
spacy125415623spac__y
spadille1145193spadille
spading113114383spading
spadix1636113spadi_x
spaeing103413543spaeing
spahi10311143spahi__
spahis11310383spahi_s
spails84817823spa_ils
spait75631603spa_i_t
spaits85017473spa_its
spall74919303spa__ll
spancel1147363spancel
spaniels1045963spaniels
sparid94016933spari_d
sparids103512123sparids
sparing104823873sparing
spartan948333spartan
spatially1446793spatially
spatula935893spatula
spavie113611383spavi_e
spavies123012943spavies
spaviet123011923spaviet
spavin114210653spavi_n
spavins12419323spavins
spaying133014623spaying
specialer1344733specialer
specially1647343specially
specialty1644303specialty
speciate12209583speciate
specie10412223speci_e
species11314133species
specify1764993specify
spectral12246193spectral
specula11187413specula
speil75618643sp_ei_l
spheral1238423spheral
spica94717943spic_a_
spicae104313703spic_ae
spicas104715823spic_as
spicier115112463spicier
spicily1438653spicily
spicing123914533spicing
spicula11259293spicula
spiel74623913sp__iel
spill74821163sp__ill
spinal84915313sp_inal
spiral83715343sp_iral
spital83813873sp_ital
splenial1047183splenial
spoil75818653sp_oi_l
sponsal946343sponsal
sporal82915453sp_oral
spousal965533spousal
stadia7312143stadia_
stadias8411113stadias
staminal1046983staminal
statal61613223sta_tal
statical1039423statical
stibial946583stibial
stoical9310283stoical
subaxial1745293subaxial
suicidal1146073suicidal
sulcal8311273sulc_al
sundial859863sundial
swail86217163swa_i_l
uncial83715223_uncial
uracil8311543uraci_l
zoarial1646923zoarial

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271826.04622167.9
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.51527427.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.