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

228 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
aspis74618141aspis_
aspish114810331aspish
apish105116632a_pish
apsis75718292apsis_
aspic95114732aspi_c
aspics104211562aspics
aspire8612122aspire
aspirin937822aspirin
aspises9611642aspises
asps65622092asp_s_
assist6314602assist
raspish1298102raspish
waspish1586922waspish
aalii5316133aali_i
aaliis6312903aaliis
abris75722603abris_
abscise1145953abscise
abscisin1243973abscisin
acini75718983a_cini
advise10139223advise
aegis6316783aegis_
ageism968803ageism
ageist7315383ageist
agism84614063a_gism
agist66325583a_gist
aguish1059283aguish
ahis76135383a_his_
ais39083573a__is_
alibi7514233a_libi
alist56136783a_list
alpine84417373alpine
alps65529243alp_s_
amici94217393a_mici
amis66445323a_mis_
amiss75823073a_miss
amping114317573amping
amps86230343amp_s_
animi74016663a_nimi
anis45746463a_nis_
anise55129703a_nise
anisic8313793a_nisic
antis55033313antis_
aorist64827873aorist
apes66047433a_pes_
aphis105917133aphis_
apian75018333a_pian
aping87327233a_ping
apos65433823a_pos_
appose10411993appose
apprise11310193apprise
apps86319693a_pps_
apse67725383a_p_se
apses76823913apses_
ariosi64313033ariosi
arise56436433a_rise
arris56824683arris_
arsis55722423arsis_
artist64125543artist
ascesis938373ascesis
asci66519143as__ci
ascidia1046683ascidia
ascitic1139323ascitic
ascus75013583ascus_
asdic83814093asdi_c
asdics9439863asdics
asepsis985903asepsis
ashes86230613ashes_
ashier94714833ashier
ashiest10313953ashiest
ashing107824093ashing
aside65122083as_ide
askesis1136123askesis
asking116017233asking
askoi9507803as_koi
askos95011773askos_
asks85721213as_ks_
aslosh966233aslosh
asp57235343asp___
aspect10612823aspect
aspen75216093asp_en
aspens85013353aspens
asper75520433asp_er
aspers86220313aspers
asperse94210663asperse
aspired1068173aspired
aspirer967903aspirer
aspires9612043aspires
aspiring1138873aspiring
aspirins1037733aspirins
ass37844063as__s_
assai5711543as_sai
assais6711963assais_
asses55629283asses_
assess65710463assess
assign736783assign
assists738473assists
assize1538633assize
astasia7310933astasia
astir55517093asti_r
aswirl935093aswirl
auris55331533auris_
aurist65027253aurist
auspice1136523auspice
autism83815333autism
autist64324943autist
aviso85713963a_viso
axis116127913a_xis_
basis75429863bas_is_
bassi77019323bas__si
bassist9312743bassist
casini84615863cas_ini
cassis84818853cassis_
casuist9411303casuist
cuspis105010703cuspis_
dampish1567663dampish
dashiki1544203dashiki
dashis104414393dashis_
despise1038683despise
espial839543espial
espied9359773espied
espies83716803espies
fascism1436443fascism
fascist1239213fascist
gasping113714363gasping
gasps85415483gasp_s_
harpist12312353harpist
hashish1238353hashish
hasping134414903hasping
hasps105114643hasp_s_
impis96213853impis_
impish13499193impish
kepis115313363kepis_
lapis76223153lapis_
lassi56316853las__si
lassis65216703lassis_
mopish134311593mopish
nisi45823243__nisi
oasis56422553oas_is_
pachisi14329523pachisi
papism122211513papism
papist102618743papist
pastis84924323pastis_
piki106520563__piki
pili66130353__pili
pis56362033__pis_
pish96127913__pish
piso66727563__piso
piss65033333__piss
popish133812113popish
psi56621623__p_si
psis68120343ps_is_
rapini84714683rapini
rapist82520673rapist
rappini11347573rappini
raspier93110643raspier
raspiest10311273raspiest
rasping104316253rasping
rasps74316663rasp_s_
sadis64930853sadis_
sadism94113493sadism
sadist74221353sadist
sakis95323673sakis_
sapid84720933sapi_d
saps65346373sap_s_
saris54544953saris_
sashimi1244643sashimi
satis55633683satis_
seis45542393_seis_
seise54727853_seise
seisin63715123_seisin
seism75019023_seism
shist84829613_shist
sips65740103_sips_
sis37360543_s_is_
skis84825293_skis_
spahi10311143_spahi
spas67036723_spas_
spasm94514173_spasm
speise84614253_speise
speiss84311643_speiss
spic85227433_spi_c
spica94717943_spica
spice95528813_spice
spick134519073_spick
spics94123243_spics
spicy125417713_spicy
spied85427713_spied
spiel74623913_spiel
spier75728033_spier
spies76037623_spies
spiff133616403_spiff
spik105419713_spi_k
spike114922843_spike
spiks114117473_spiks
spiky146014113_spiky
spile75230083_spile
spill74821163_spill
spilt75532223_spilt
spin66231303_spi_n
spine76534423_spine
spins75327983_spins
spiny104921303_spiny
spire75828693_spire
spirit83519923_spirit
spirt75032953_spirt
spiry105017353_spiry
spit65545083_spi_t
spite75430663_spite
spits74429553_spits
spitz166017973_spitz
spiv95917793_spi_v
spivs105114243_spivs
sris45434153_sris_
swish115114823_swish
swiss86712903_swiss
tapis75028863tapis_
tipis76019923tipis_
topis76025833topis_
typist1139823typist
uppish1336633uppish
vampish1766283vampish
wampish1777293wampish
wapiti1138363wapiti
waspier12259053waspier
waspiest1338813waspiest
waspily1535513waspily
wasps106714693wasp_s_
wispish1575643wispish

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162285.45320670.5
3Display Results2282280.0802850.0
 (SQL Overall)1786912285.67331498.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.