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

94 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
teethings134423(None) 
teething1237161teething_
meetings11287412meet_ings
naethings1343872naethings
seething1239022seething_
teachings15296552teachings
tithings12327692t_ithings
trithings13246602trithings
anythings1642593anythings
beatings114113233beat_ings
beestings12335923beestings
beeswings15293303beeswings
beetling1139283beetling_
beltings11369253belt_ings
berthing14209593berthing_
bethinks1765043_bethinks
birthings15254623birthings
breathings16234313breathings
breechings18273723breechings
centrings12227603centrings
clothings15264433clothings
eatings84616443_eat_ings
etchings14396293_etchings
farthings1635233farthings
feelings12338933fee_lings
feltings12317903felt_ings
fettlings1353753fettlings
fleshings16335383fleshings
fletchings19282863fletchings
greetings11276043greet_ings
heelings12359753hee_lings
jestings16368023jest_ings
keepings15345943kee_pings
lathings12469853_lathings
leeching14318373leeching_
loathings1344213loathings
meeting103314963meet_ing_
methinks1775193_methinks
naething1236073naething_
needlings11294693needlings
nestlings1074313nestlings
nettings9288103_nettings
northings13185573northings
nothings12266683_nothings
peelings11339523pee_lings
pettings11349703_pettings
reedings103510363ree_dings
reedlings11236343reedlings
reelings94012563ree_lings
restrings10159293restrings
rethinks1576033_rethinks
seatings93614303seat_ings
seedlings11195953seedlings
seeings84411293see__ings
seemings11337643see_mings
settings93810073_settings
settlings1054683settlings
sheathings1743913sheathings
sheetings13256713sheet_ings
somethings1642993somethings
southings13246233southings
steevings13284443stee_vings
sweetings13326183sweet_ings
tattings9408823t_attings
teaching143612603teaching_
teeing73916973tee__ing_
teeming103513093tee_ming_
teetering10239893teetering_
teethers11328713teeth_ers
teethes103611653teeth__es
teethless1243703teethless
teethridge1551013teethridge
teethridges1651043teethridges
telethons1246013telethon_s
tenting84621153tent_ing_
testing86021053test_ing_
thatchings1942483thatchings
things104914303___things
tintings9288713tint_ings
tithing113513893t_ithing_
toothing12278863toothing_
trephines1448483trephines
trithing122811773trithing_
trothing122410843trothing_
tuftings12264323tuft_ings
turtlings10184873turtlings
tweeting12267033tweet_ing_
tything14316573t_ything_
vestings12359143vest_ings
weepings14346483wee_pings
weeting113816053weet_ing_
weltings12388203welt_ings
westings12429803west_ings
wettings12348403_wettings

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.1731032896.0
2DLD Change Limit148641947.82618993.2
3Display Results94940.0462043.5
 (SQL Overall)178691948.04522211.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.