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

205 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
shirtings1327660(None) 
shirrings13245321shirrings
shirting123213611shirting_
skirtings14274561skirtings
shaftings16224182shaftings
sheetings13256712sheetings
shielings13237122shielings
shifting152910382shifting_
shillings13348092shillings
shippings17275682shippings
shirking163210472shirking_
shirring122910442shirring_
shitting123212662shitting_
shootings13266062shootings
shorings12269482shor_ings
shorting122514802shorting_
siftings12236582s_iftings
sittings9339732s_ittings
skirting13289392skirting_
spirting112913632spirting_
stirrings10224692stirrings
suitings9288952sui_tings
whitings15287062whi_tings
airings83913843_air_ings
airting83616303_airting_
birdings12378823_birdings
birlings11359613_birlings
birthings15254623_birthings
bittings11339293_bittings
charting142614193charting_
chirking18339383chirking_
chirming16318643chirming_
chirping16278863chirping_
chirring142610173chirring_
chitins122713793chi_tin_s
chitlings15255903chitlings
churnings15233403churnings
dairyings1442633dairyings
fairings12388193fair_ings
firings114112333_fir_ings
fittings12318203_fittings
flirting12319013flirting_
ghostings1433483ghostings
girting93113333_girting_
harpings14379773_harpings
herrings12379533_herrings
hidings12349703_hi_dings
hildings13347503_hildings
hilting113316893_hilting_
hinting113919223_hinting_
hirelings1365763_hirelings
hiring104421603_hir_ing_
hissings12556753_hissings
histing113720373_histing_
hitting113017273_hitting_
hornings12238363_hornings
huntings12328053_huntings
hurlings12388213_hurlings
hurting113914033_hurting_
hustings12378683_hustings
kartings13418523_kartings
kiltings13327083_kiltings
knittings14273453knittings
listings93310043_listings
paintings12327093paintings
pairings11398313pair_ings
partings113513733_partings
pharmings17254723pharmings
pittings11349123_pittings
printings12268103printings
quiltings19214683quiltings
quirting18238383quirting_
sacrings11278923sacr_ings
sailings93513253sai_lings
sainting93215733sainting_
saltings92811253s_altings
scarting113415263scarting_
schillings16243273schillings
scoutings12306143scoutings
seatings93614303s_eatings
seisings9398523sei_sings
seizings18326473sei_zings
sergings10299213s_ergings
servings12249223s_ervings
settings93810073s_ettings
shadings13327433sh_adings
shafting15278683shafting_
shantungs1341653shantungs
sharing113723243shar_ing_
sharking163912973sharking_
sharping143011373sharping_
shavings15356333sh_avings
shealings13317563shealings
shearings13337563shearings
shearlings1443533shearlings
sheathings1743913sheathings
sheeting122712833sheeting_
shelvings16283823shelvings
shieling123512403shieling_
shiftiness1644793shiftiness
shilingi1233843shi_lingi
shilling123315383shilling_
shimming16278253shimming_
shindigs13284203shindi_gs
shining113816523shi_ning_
shinning123211023shinning_
shipping163611253shipping_
shirtier1137943shirti_er
shirtiest1239333shirtiest
shirtless12266413shirtless
shirts94918343shirt___s
shittims1344423shitti_ms
shooting122812863shooting_
shoppings17295073shoppings
shoring112820073shor_ing_
shortenings1542683shortenings
shortens11288993shorten_s
shortias1148093shorti_as
shorties11414583shorti_es
shotting123012383shotting_
shouting122711793shouting_
showings15246883sh_owings
showrings1644063showrings
shrines104618693sh_r_ines
shrining122610853shrining_
shrinks14397913sh_r_inks
shriving15268453shriving_
shuckings19273853shuckings
shunting123610433shunting_
shuting113212053sh_uting_
shutting12309693shutting_
siblings11108123s_iblings
sidings94011463s_i_dings
sifting113014593s_ifting_
sightings14256533sightings
silting83320483s_ilting_
siring75128313s_ir_ing_
siting74126623s_i_ting_
sitting83519633s_itting_
sizings17378013s_i_zings
skatings13326993s_katings
skiings12295733ski__ings
skillings14246133skillings
skimmings18243263skimmings
skiorings14243793skiorings
skirling13249063skirling_
skirring13297143skirring_
skiting123812503ski_ting_
slatings94011723s_latings
slattings10346073slattings
slitting93012583slitting_
smarting113212453smarting_
smirking15277233smirking_
smiting103014443smi_ting_
snorting92613373snorting_
soarings93210393soar_ings
sorings83817253s_or_ings
sorting83221813s_orting_
sparlings12257153sparlings
spartinas1135793spartinas
spilings11308813spi_lings
spinnings12294853spinnings
spiring103918183spir_ing_
spiriting1238413spiriting_
spiting103917623spi_ting_
spitting113012323spitting_
sporting112415463sporting_
spoutings12245153spoutings
springs104415923s_pr_ings
spurting113111633spurting_
squirting1934793squirting_
starlings10237923starlings
starting93116173starting_
sterlings10308753sterlings
stilting93312403stilting_
stings76220183s___tings
stinting93415743stinting_
stirring9299653stirring_
strings84617133s_tr_ings
stripings12215203stripings
subrings11229883subr_ings
suiting83419003sui_ting_
surfings12268073s_urfings
sweetings13326183sweetings
swimmings17263153swimmings
swingings14275053swingings
swirling12249143swirling_
thinkings17255053thinkings
thirling12248583thirling_
thirsting1335283thirsting_
thirties1139723thirti_es
tintings9288713_tintings
twistings13264353twistings
waistings1352710763waistings
waitings123413743wai_tings
whippings20284183whippings
whirling15237163whirling_
whirring15286283whirring_
whisting15329543whisting_
whistlings1742913whistlings
whiting143311303whi_ting_
whittlings1742223whittlings
wirings113910113_wir_ings
wittings12328733_wittings
writings12298113wri_tings

Search took 10 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 Limit1486412058.81316866.1
3Display Results2052050.0932204.3
 (SQL Overall)1786912059.35919093.0
 
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.