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

221 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
spirant981429(None) 
aspirant1048861aspirant
spirants1088281spirants
aspirants1145232aspirants
operant9317222operant
pirana8713262_pirana
spiraea9407982spiraea
spiral83715342spira_l
spirals93212512spirals
spiring103918182spiring
spirit83519922spir_it
spirt75032952spir__t
sprang95713522sp_rang
sprat76635972sp_ra_t
sprent84522382sp_rent
sprint84526792sp_rint
apian75018333api_an_
arrant6623253_arrant
aspirata1054993aspirata
aspirate1039943aspirate
aspirin937823aspirin_
aspiring1138873aspiring
aspirins1037733aspirins
brant74742173__brant
brisant9312683brisant
courant9317973courant
currant9314173currant
emigrant1148563emigrant
entrant7318873entrant
errant6618733_errant
giant65430593_gi_ant
grant64840023__grant
hydrant1489053hydrant
intrant7318753intrant
iterant7317783iterant
jurant134216553_jurant
migrant10314313migrant
odorant8411393odorant
operand1038003operand
operants1039483operants
oppilant1246023oppilant
oscitant1046903oscitant
oxidant1547363oxidant
pant66061263_p__ant
parang93715513_parang
parent83230423_parent
pedant9319493_pedant
pian66136093_pi_an_
piano76118713_pi_ano
pians75126963_pi_ans
picante11310523_picante
pinang92611593_pinang
pint66963173_pi__nt
piquant1848003_piquant
piracy1339473_piracy
piranas9912603_piranas
piranha12126363_piranha
pirate82322883_pirate
piraya1167713_piraya
pirn67128373_pir_n_
pirns76020093_pir_ns
pissant91012503_pissant
plant75437113_p_lant
pliant83918823_pliant
prang84820323_p_rang
prank115019453_p_rank
prat65952043_p_ra_t
print74837463_p_rint
purana8712933_purana
pyran10514473_pyran_
pyrans11411063_pyrans
rant45864683___rant
regrant8317323regrant
retirant8313593retirant
riant55833153_ri_ant
saint55147073sai__nt
saltant7316773saltant
sapient9415343sapi_ent
saran53730303s_aran_
sarans64224433s_arans
saturant8410643saturant
savant9416043s_avant
scant79735073s__cant
sealant73118303sealant
seawant103613413seawant
secant84023293s_ecant
seitan62613233seitan_
seitans73312303seitans
sejant133114483s_ejant
sejeant1489723sejeant
serrano768463serrano
servant10313633servant
sextant142911963sextant
shirt84533903shir__t
shoran94016043shoran_
shorans102812413shorans
shrank13359123s_hrank
sibilant10158273sibilant
silane62718053s_ilane
silent64125843s_ilent
siren54525823s_iren_
sirens65318153s_irens
siring75128313s_iring
skint95629223ski__nt
skirret11278173skirret
skirt95624663skir__t
slant55238703s__lant
sonant6621953s_onant
sonorant8411703sonorant
soprani937403soprani
soprano937003soprano
sovran937153sovran_
sovrans1036483sovrans
sovranty1443463sovranty
spait75631603sp__ait
span65234663sp__an_
spang84919733sp__ang
spank115919573sp__ank
spans74528733sp__ans
sparest94616433sparest
sparing104823873sparing
spartan948333spartan_
spat66548523sp__a_t
spean74620513sp_ean_
speans85417143sp_eans
speiring113711263speiring
spent75532833sp__ent
spica94717943spica__
spicae104313703spica_e
spicas104715823spica_s
spicate113214193spicate
spicing123914533spicing
spiering112713353spiering
spigot9312603spi_got
spiking144312883spiking
spiling102919703spiling
spilt75532223spi__lt
spin66231303spi__n_
spinach1435403spinach
spinage10289653spinage
spinal84915313spina_l
spinals93911863spinals
spinate93114813spinate
spine76534423spi__ne
spinet85629753spi_net
spinny114510183spi_nny
spinout9311583spinout
spins75327983spi__ns
spinto8410663spi__nto
spiny104921303spi__ny
spiracle1255803spiracle
spiraeas10286233spiraeas
spiraled1137733spiraled
spiraling1237953spiraling
spirality1446433spirality
spirally1348023spirally
spire75828693spir__e
spirea84015633spir_ea
spireas94412513spireas
spired94921863spir_ed
spirem104214163spir_em
spireme11478363spireme
spirems11499563spirems
spires84628113spir_es
spirier93214073spirier
spiriest102513463spiriest
spirits94112623spirits
spiroid10219823spiroid
spirted103913073spirted
spirting112913633spirting
spirts85317133spir_ts
spirula9257703spirula
spiry105017353spir__y
spit65545083spi___t
spital83813873spita_l
spitals93011593spitals
spiting103917623spiting
splat76129343sp_la_t
splent84720193sp_lent
splint85223283sp_lint
sporal82915453spora_l
sporing104319413sporing
sporran936743sporran_
sporrans1045523sporrans
sport75935983spor__t
sprag86418693sp_ra_g
sprags95715823sp_rags
sprain83614863sp_rain
sprains93013593sp_rains
sprangs104610053sp_rangs
sprats85819933sp_rats
sprawl11188063sp_rawl
spray106720063sp_ra_y
sprays115913643sp_rays
spriest92718653spriest
spright132010403spright
spring94526013sp_ring
sprints94113773sp_rints
sprit76736403sp_r_it
sprout8419403sp_rout
sprung94610033sp_rung
spurn74815453spur_n_
spurns84811383spur_ns
spurt77227983spur__t
statant7313123statant
stint57037663sti__nt
strait64025893s_trait
strand74514823s_trand
strang75718313s_trang
strunt64918913s_trunt
subrent9315083subrent
suint55638183sui__nt
supplant1247823supplant
titrant7315193titrant
tyrant9315333_tyrant
updraft1346033updraft
upfront1246973upfront
vagrant11410663vagrant
variant10316803variant
vibrant12410393vibrant
warrant10614243warrant

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 Limit1340272216.95319276.1
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.43924020.8
 
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.