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 “streakings” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
streakings1523530(None) 
streaking142010321streaking_
streamings13185161streamings
breakings16297062_breakings
phreakings2043192phreakings
screaking16228242screaking_
speakings16345932s_peakings
steadings11307082st_eadings
stealings10318852st_ealings
streakiness1543822streakiness
streaming12239652streaming_
streeking14217452streeking_
breaking153914253_breaking_
caretakings1852903caretakings
creaking153414123_creaking_
estreating11710363estreating_
freaking163611453_freaking_
phreaking1936473phreaking_
readings103512643__readings
rereadings12124543rereadings
scrapings14255173scr_apings
screaming14217833screaming_
screenings1343263screenings
seatings93614303s__eatings
shealings13317563s_healings
shearings13337563s_hearings
sneaking133211093s_neaking_
speaking153212493s_peaking_
spreading1339653spreading_
squeaking2334213squeaking_
stagings10378343st__agings
staking123919803st__aking_
stalkings14314983st_alkings
stargazings22101703stargazings
steading103613593st_eading_
stealing93416603st_ealing_
steaming114013213st_eaming_
stearines9311283st_earines
stearins8312143st_earin_s
steeking133411353st_eeking_
steelmakings19122003steelmakings
steevings13284443st_eevings
sterlings10308753st_erlings
stockings16296093st_ockings
strafing122111193str_afing_
strains74218153str_a_in_s
strappings1543353strappings
strawing122411623str_awing_
straying122912693str_aying_
streakers13218133streak_ers
streakier1334843streaki_er
streakiest1444763streakiest
streakily1643673streaki_ly
streaks114411273streak___s
streamlines1343643streamlines
streeling10189483streeling_
stressing1038333stressing_
strewing12289853stre_wing_
striating10914193striating_
striking133012233str_iking_
stringings1245233stringings
strings84617133str___ings
stripings12215203str_ipings
striplings1344183striplings
stroking132610943str_oking_
stroudings1242743stroudings
surfacings1642453surfacings
takings124512573_t__akings
tracings112910413_tr_acings
trackings16247543_trackings
treading103515333_treading_
treating92519613_treating_
trekking1235543_trekking_
troaking133310973_troaking_
truckings16235023_truckings
tweaking1635883_tweaking_
wreaking163010213_wreaking_
wreckings19233683_wreckings

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 Filter1786911406030.406440125.6
2DLD Change Limit140603786.75020830.1
3Display Results78780.0332363.6
 (SQL Overall)178691787.18924856.2
 
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.