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

212 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
spatial931032(None) 
spacial1138761spacial
spathal1236261spathal
partial92616262_partial
spail74921552spa_i_l
spaniel948922spaniel
spatially1446792spatially
spatula935892spatula
special11310302special
spital83813872spit_al
statal61613222stat_al
statical1039422statical
abaxial1646183abaxial
abbatial1284673abbatial
adagial946373adagial
adaxial1545323adaxial
apatite9312963apatite
atrial65418943__atrial
axial124515193__axial
bestial9311643bestial
biaxial1645363biaxial
capital112311523capital
coaxial16157003coaxial
cranial92114683cranial
datival1135583_datival
especial1246293especial
espial839543esp__ial
facial113615633_facial
fatal84819373_fat_al
fetial95716193_fetial
gavial10310083_gavial
gharial1137343gharial
glacial1038143glacial
gnathal1144353gnathal
haptical1547343haptical
hiatal9310203hiat_al
impartial1345183impartial
initial7311883initial
labial84714343_labial
martial92415413martial
matinal9312603_matinal
meatal84114733meat_al
narial6317953_narial
nasial6413283_nasial
natal53921493_nat_al
nonspatial1255623nonspatial
nuptial946633nuptial
optical1149863op_tical
optimal1145783op_timal
ovarial1037613ovarial
paginal10269493_paginal
pail66141833_pa_i_l
palatial10410623palatial
paleal84716673_paleal
pallial92911253_pallial
palpal104112053_palpal
papal95820673_pa_pal
pariah114320583_pariah
parian83223963_parian
parral85517533_parral
partials101911953_partials
pascal10812373_pascal
pastil85018323_pasti_l
patagial1157173_patagial
patin76832853_pati_n
patina86022193_patina
patinae95414403_patinae
patinas96318523_patinas
patine85328123_patine
patins87528783_patins
patio74426353_pati_o
patios85221783_patios
patrol83213023_patrol
pausal81511963_pausal
penial84120893_penial
petal76526893_pet_al
phial10313203_p_hial
pial65636703_p__ial
puparial1246313puparial
racial83419243_racial
radial74020393_radial
ratal55025113_rat_al
retial64724993_retial
sabal75422483s_a_bal
sacral83414413s_acral
sahiwal1344443s_ahiwal
sail45447163s_a_i_l
salal55425703s_a_lal
sambal105215183s_ambal
samiel8313333s_amiel
sandal73317283s_andal
satay84718463s_at_ay
sati45539333s_ati__
satiable10310733s_atiable
satiably1337823s_atiably
satiate7315403s_atiate
satin55935223s_ati_n
sating74735453s_ating
satins64930483s_atins
satiny93817983s_atiny
satire63218003s_atire
satis55633683s_ati_s
satrap86212553s_atrap
scandal1038673scandal
scotia8310803scotia_
scotias939753scotias
seating84130683seating
septal84513383sept_al
septical1259363septical
serial64625863s_erial
setal56430903s_et_al
shaitan1036893shaitan
sharia93116733sharia_
shariah132210533shariah
sharias102516003sharias
sial45938833s___ial
skating123613853skating
skatol1035723skat_ol
slatier74016813slatier
slating83724653slating
snail57020203sna_i_l
social8813333s_ocial
solatia7312253solatia_
somital939403somital
spacially1645653spacially
spacier114011633spacier
spacing123614493spacing
spadille1145193spadille
spading113114383spading
spadix1636113spadi_x
spaeing103413543spaeing
spahi10311143spahi__
spahis11310383spahi_s
spails84817823spa_ils
spait75631603spa_i_t
spaits85017473spa_its
spall74919303spa__ll
spancel1147363spancel
spaniels1045963spaniels
sparid94016933spari_d
sparids103512123sparids
sparing104823873sparing
spartan948333spartan
spartina1037983spartina
spartinas1135793spartinas
spastic11310383spasti_c
spastics1237503spastics
spat66548523spat___
spate74731583spat__e
spates85028173spat_es
spathe115115693spat_he
spathed134013183spathed
spathes125116533spathes
spathic1437543spathic
spatiality1544403spatiality
spats75031383spat__s
spatted104014143spatted
spatter94016523spatter
spatting113111763spatting
spatular1044653spatular
spatulas1045473spatulas
spatzle1834583spatzle
spavie113611383spavi_e
spavies123012943spavies
spaviet123011923spaviet
spavin114210653spavi_n
spavins12419323spavins
spaying133014623spaying
specials1238033specials
spectral12246193spectral
speil75618643sp_ei_l
spermatial1445673spermatial
spheral1238423spheral
spiel74623913sp__iel
spill74821163sp__ill
spinal84915313sp_inal
spiral83715343sp_iral
spitals93011593spit_als
spitball1244493spitball
spiting103917623spiting
splenial1047183splenial
spoil75818653sp_oi_l
sponsal946343sponsal
sporal82915453sp_oral
spousal965533spousal
sputa74612963sput_a_
stadia7312143stadia_
stadias8411113stadias
staminal1046983staminal
static83118683stati_c
statice92614033statice
statics93314533statics
statin63921473stati_n
stating83725163stating
statins73719773statins
station72717243station
stational948513stational
statism9412283statism
statist7317723statist
stative102612933stative
steal56125473s__teal
stibial946583stibial
still54922083s__till
stratal72710603strat_al
subaxial1745293subaxial
sundial859863sundial
swail86217163swa_i_l
tertial7313863tertial
vatical1239983_vatical
viatical1347063viatical
zaptiah2144293zaptiah
zoarial1646923zoarial

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.406440125.6
2DLD Change Limit1340272127.20018614.9
3Display Results2122120.0962208.3
 (SQL Overall)1786912127.70223200.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.