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

187 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
spiraling123795(None) 
spiralling1343961spiralling
aspirating1348362aspirating
pirating11314512_pirating
skirling13249062skir_ling
sparkling16226352sparkling
sparling112714532spar_ling
spieling113212522spi_eling
spiling102919702spi__ling
spilling113113942spi_lling
spindling13136272spindling
spirality1446432spirality
spiring103918182spir__ing
spiriting1238412spiriting
spirting112913632spir_ting
spirulina1143422spirulina
sprawling15175122sp_rawling
spraying14299882sp_raying
swirling12249142swir_ling
appealing1446493appealing
asperating1349563asperating
aspiring1138873aspir__ing
birling104317053_bir_ling
circling1338423_circling
dialing94318173_di_aling
dirling93316073_dir_ling
epilating12310973epilating
girdling1146823_girdling
hireling121210993_hireling
hirpling1467223_hirpling
hirsling1277543_hirsling
operating12313723operating
opiating11410093opi_ating
paling93530133_p__aling
parading12313863_parading
parawing14310583_parawing
parling103823763_par_ling
paroling113316213_paroling
pealing104123203_p_ealing
pearling11912013_pearling
pedaling122412133_pedaling
periling11316863_periling
phrasing1438013_phrasing
pickling17239203_pickling
piddling13208953_piddling
piffling1745133_piffling
piling95025593_pi__ling
pilling103722563_pi_lling
pindling122110983_pindling
praline93019743_p_raline
prating103424453_p_rating
praying133717323_p_raying
prilling113413413_prilling
purfling1467763_purfling
purling103620293_pur_ling
purpling1368543_purpling
rivaling1239913_rivaling
sailing83927373sai__ling
sandaling112010563sandaling
scaling103519373s__caling
scraping133310863s_craping
scrawling15195583s_crawling
sealing83528563s__ealing
separating1348643separating
seriating10916403seriating
serrating10513213serrating
shealing123415463s_healing
shearling1336923shearling
shieling123512403shi_eling
shilling123315383shi_lling
shingling14136973shingling
shirking163210473shir_king
shirring122910443shir_ring
shirting123213613shir_ting
shoaling123111753s_hoaling
shrilling13307693shrilling
sibling10814423s_i_bling
sickling152910333s_ickling
sideling101012183s_ideling
sidling9915423s_i_dling
signaling1136563signaling
singling101913003s_ingling
siring75128313s_ir__ing
siruping1136503s_iruping
sizzling17225783s_izzling
skiffling2043103skiffling
skilling132911333ski_lling
skirring13297143skir_ring
skirting13289393skir_ting
skoaling13227213s_koaling
smiling103915443smi__ling
smirching1744393smirching
smirking15277233smir_king
snarling92513183snar_ling
sniffling1644093sniffling
sniggling1244413sniggling
sniveling1336033sniveling
soiling83422323soi__ling
spacing123614493sp__acing
spackling18266503spackling
spading113114383sp__ading
spaeing103413543sp__aeing
spalling113213463sp_alling
spangling1336373spangling
sparging122611133spar_ging
sparing104823873sp__aring
sparking152812543spar_king
sparlings12257153spar_lings
sparring113112223spar_ring
spaying133014623sp__aying
speaking153212493sp_eaking
speaning113512243sp_eaning
spearing113216103sp_earing
speckling18235583speckling
speeling112713123sp_eeling
speiling113612973sp_eiling
speiring113711263speir__ing
spelling113315233sp_elling
spicing123914533spi__cing
spiering112713353spi_ering
spiffing17237083spi_ffing
spiffying2142753spiffying
spiking144312883spi__king
spilings11308813spi__lings
spinning113310813spi_nning
spiral83715343spiral___
spiraled1137733spiral_ed
spiralled1244403spiralled
spirally1348023spiral_ly
spirals93212513spiral__s
spirant9814293spira__nt
spirulinas1242053spirulinas
spiting103917623spi__ting
spitting113012323spi_tting
splaying14219303sp_laying
spoiling112911553sp_oiling
spooling113212563sp_ooling
sporing104319413spor__ing
sporting112415463spor_ting
spraddling1542313sp_raddling
sprain83614863sp_ra_in_
spraining1248153sp_raining
sprains93013593sp_ra_ins
sprang95713523sp_ra__ng
sprattling1363053sp_rattling
spreading1339653spreading
sprigging1435893sprigging
spring94526013sp_r__ing
springing1338743springing
sprinkling1743823sprinkling
sprinting12310033sprinting
spritzing2135393spritzing
sprucing1336893sp_rucing
spurgalling1551723spurgalling
spurning11258663spur_ning
spurring11339763spur_ring
spurting113111633spur_ting
squealing1935153squealing
staling83925423s__taling
starling93017123star_ling
startling1037373startling
stealing93416603s_tealing
sterling93615553ster_ling
stickling1647003stickling
stifling122110913sti_fling
stilling93415323sti_lling
stippling1475173stippling
stirring9299653stir_ring
strafing122111193s_trafing
strawing122411623s_trawing
straying122912693s_traying
striating10914193striating
stripling1257783stripling
supinating1357833supinating
swilling123511933swi_lling
swindling14135833swindling
swingling14156203swingling
swiveling1634573swiveling
swizzling2142493swizzling
thirling12248583thir_ling
tirling83315733_tir_ling
twirling12246243twir_ling
upgrading1444903upgrading
uprating11311113up_rating
upscaling1444653upscaling
vialing113614163_vi_aling
whirling15237163whir_ling

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit1486411877.90618801.0
3Display Results1871870.0762460.5
 (SQL Overall)1786911878.43521184.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.