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

146 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
shortias114809(None) 
shortia1048191shortia_
shorties11414581shorties
scotias939752sco_tias
sharias102516002shar_ias
shortens11288992shortens
shortie10411342shorti_e
shorting122514802shorting
shortish1437422shortish
shorts95321742short__s
sorties74126402s_orties
thorias102312052thor_ias
aortas65417783_aort_as
aporias9315153apor_ias
choreas124414203chor_eas
chorial124214143chor_ial
choroids1438693choroids
chortens13308793chortens
chortles133611323chortles
cortinas102212443_cortinas
cortins92421333_cortins
dhooties1237643dhooties
dhootis1135683dhooti_s
dhotis1038973dho_ti_s
forties104323863_forties
fortis95418613_forti_s
glorias81610323glor_ias
hernias10310773_hernias
hogties112813993_hogties
horas86333103_hor__as
hostas94515823_host_as
hotties103016963_hotties
inertias8410383inertias
norias65518203_nor_ias
phobias14228183pho_bias
photics142810483pho_tics
scoria8513503scor_ia_
scoriae9310903scor_iae
scotia8310803sco_tia_
scotties1039753scotties
senhoritas1353073senhoritas
senoritas946513senoritas
shanties113116583shanties
shantihs14276213shantihs
shantis103313103shanti_s
sharia93116733shar_ia_
shariah132210533shar_iah
shariahs14206393shar_iahs
sharifs13279903shar_ifs
sharpies13411223sharpies
sheltas10279673shelt_as
shelties111111383shelties
sherifs13299683sher_ifs
sherpas1238093sher_pas
sherries111812893sherries
sherris10168803sherri_s
shirtier1137943shirtier
shirtiest1239323shirtiest
shirting123213613shirting
shirtings13276603shirtings
shirts94918343shirt__s
shittims1344423shittims
shoats94117083shoat__s
shoddies1336053shoddies
shogis103810943sho_gi_s
shojis16348493sho_ji_s
shooters112811583shooters
shooting122812863shooting
shootings13266063shootings
shoots94619363shoot__s
shoran94016043shor__an
shorans102812413shor_ans
shores94830413shor__es
shoring112820073shor_ing
shorings12269483shorings
shorls94516203shor__ls
short85040533short___
shortage1236313shortage
shortages1336513shortages
shortcake1843203shortcake
shortcakes1943023shortcakes
shortcut1344453shortcut
shortcuts1442513shortcuts
shorted113614403short_ed
shorten103511413short_en
shorter103515503short_er
shortest11310783shortest
shortfall1542873shortfall
shortfalls1652913shortfalls
shorthair1543023shorthair
shorthairs1672813shorthairs
shorthand1643753shorthand
shorthands1743493shorthands
shorthead1644473shorthead
shortheads1743813shortheads
shortlist1246683shortlist
shortlists1344083shortlists
shortly13387573short_ly
shortness1236733shortness
shortwave1842483shortwave
shortwaves1942563shortwaves
shorty124313203short__y
shotes95321913sho_t_es
shots84730853sho_t__s
shotting123012383shotting
shotts93614703sho_t_ts
shouters113510623shouters
shouting122711793shouting
shouts94017723shout__s
showtime1643773showtime
showtimes1743653showtimes
shris84221453sh_r_i_s
shtiks13297833sh__tiks
skorts104211303skort__s
smarties10312873smarties
snorters83410583snorters
snorting92613373snorting
snorts64116503snort__s
softas94410403s_oft_as
softies103414613s_ofties
soras55041013s_or__as
sorites73825243s_orites
sorta57125413s_ort_a_
sorters74221133s_orters
sortie63621993s_orti_e
sortied83314103s_ortied
sorting83221813s_orting
sorts54536663s_ort__s
spartinas1135793spartinas
sporters103714063sporters
sportier102010053sportier
sportiest111711023sportiest
sportif1238803sporti_f
sportily1337733sportily
sporting112415463sporting
sportive1348333sportive
sports84619183sport__s
stories7324273stor_ies
stotins73213873sto_tins
strontias945603strontias
thirties1139723thirties
thoria93012893thor_ia_
thorites11312393thorites
tortas64918253_tort_as
whortles14306743whortles
whorts125111433whort__s

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621467.66019081.2
3Display Results1461460.0602433.3
 (SQL Overall)1786911467.87322696.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.