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

50 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
skivvied197181(None) 
skivvies18112881skivvies
chivvied2052522chivvied
divvied1544812_divvied
savvied1433802s_avvied
skived14429892ski_v_ed
chivied16368383chi_vied
chivvies1954423chivvies
civvies1555843_civvies
divvies1457663_divvies
ivied94710523__i_vied
kidvid1535023_kidvi_d
savvier1335483s_avvier
savvies1337603s_avvies
shimmied16294983shimmied
shinnied12345823shinnied
shivered15177103shivered
sieved104611443s_iev_ed
skidded1465083ski_dded
skiddier1464193skiddier
skidooed1442623skidooed
skied104417753sk___ied
skiffled19244423skiffled
skilled123110863ski_lled
skimmed16306053ski_mmed
skimped16256223ski_mped
skimpier1634293skimpier
skinked11339013ski_nked
skinned12387293ski_nned
skinnier1264893skinnier
skipped16358413ski_pped
skirled12348183ski_rled
skirred12347073ski_rred
skirted12388613ski_rted
skited114313473ski__ted
skive124614113ski_v_e_
skiver134612103ski_v_er
skives134113943ski_v_es
skiving15298373ski_ving
skivvy1932783skivv__y
skivvying2391603skivvying
skydived2051563skydived
slivered12218103slivered
sniveled1255463sniveled
spiffied17234823spiffied
stimied10310623sti_mied
stithied1235303stithied
survived1534073survived
swived133610633swi_v_ed
swiveled1544163swiveled

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162508.72016761.7
3Display Results50500.0301666.7
 (SQL Overall)178691508.92320025.9
 
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.