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

138 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
stirrings1022469(None) 
shirrings13245321shirrings
stirring9299651stirring_
shirring122910442shirring_
shirtings13276602shirtings
skiorings14243792skiorings
skirring13297142skirring_
skirtings14274562skirtings
starlings10237922starlings
starring92312952starring_
sterlings10308752sterlings
strings84617132st__rings
stripings12215202stripings
airings83913843_ai_rings
bestirring1343993bestirring_
birdings12378823_birdings
birlings11359613_birlings
birring103713063_birring_
chirring142610173chirring_
dairyings1442633dairyings
earrings9299633_earrings
fairings12388193fai_rings
firings114112333_fi_rings
furrings12317143_furrings
herrings12379533_herrings
pairings11398313pai_rings
sacrings11278923s_acrings
sailings93513253sai_lings
scarring112511513scarring_
sciurines1144683sciurines
scourings12235293scourings
seisings9398523sei_sings
seizings18326473sei_zings
sergings10299213s_ergings
servings12249223s_ervings
shearings13337563shearings
shielings13237123shielings
shillings13348093shillings
shippings17275683shippings
shirking163210473shirking_
shirting123213613shirting_
shorings12269483s_horings
showrings1644063showrings
siblings11108123s_iblings
sidings94011463s_i_dings
siftings12236583s_iftings
siring75128313s_i_ring_
sittings9339733s_ittings
sizings17378013s_i_zings
skiings12295733ski__ings
skijorings2241443skijorings
skillings14246133skillings
skimmings18243263skimmings
skioring13237223skioring_
skirling13249063skirling_
skirting13289393skirting_
slurring9288833slurring_
smirking15277233smirking_
soarings93210393s_oarings
sorings83817253s__orings
sparlings12257153sparlings
sparring113112223sparring_
speerings12276843speerings
spiering112713353spiering_
spilings11308813spi_lings
spinnings12294853spinnings
spiring103918183spi_ring_
spirting112913633spirting_
springs104415923s__prings
spurring11339763spurring_
stablings12256103stablings
stagings10378343st_agings
stalkings14314983stalkings
standings11257153standings
staring84527053st_aring_
starling93017123starling_
starting93116173starting_
starving122510173starving_
steadings11307083steadings
stealings10318853stealings
stearines9311283stearines
stearins8312143stearin_s
steering93916793steering_
steevings13284443steevings
sterling93615553sterling_
stibines1038153sti_bines
sticking153513463sticking_
stiffing15248703stiffing_
stifling122110913stifling_
stilling93415323stilling_
stilting93312403stilting_
stimying1437503stimying_
stinging103213453stinging_
stings76220183st___ings
stinking133113543stinking_
stinting93415743stinting_
stipplings1582373stipplings
stirrers8266943stirr_ers
stirrups1042603stirr_ups
stockings16296093stockings
storing83921123st_oring_
storming11209423storming_
storying12249673storying_
strains74218153st_rain_s
striding102713603striding_
striking133012233striking_
string75327563st__ring_
stringings1245233stringings
stringy114111073st__ringy
striping112612523striping_
striplings1344183striplings
striving122611393striving_
studdings1242933studdings
stuffings16233493stuffings
stylings12276233st_ylings
subrings11229883s_ubrings
suitings9288953sui_tings
surfings12268073s_urfings
swimmings17263153swimmings
swingings14275053swingings
swirling12249143swirling_
tarring83318303_tarring_
terrines82117553_terrines
tickings15368583_tickings
tidings93810263_ti_dings
tiering8315253_tiering_
tilings84212793_ti_lings
timings10279303_ti_mings
tintings9288713_tintings
tiring74023093_ti_ring_
tirling83315733_tirling_
tithings12327693_tithings
tourings9277373_tourings
turnings9287233_turnings
upstirring1342243upstirring_
whirring15286283whirring_
wirings113910113_wi_rings
yirring11307763_yirring_

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.406440125.6
2DLD Change Limit1486411387.58019609.6
3Display Results1381380.0602300.0
 (SQL Overall)1786911388.04622208.7
 
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.