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

37 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
skyhook164258(None) 
skyhooks1742251skyhooks
shook124920162s__hook
boyhood1646493boyhood
chook146015043__chook
daybook1744373daybook
eyehook1743343eyehook
hook116133283___hook
kook75822603_k__ook
pothook1656883pothook
schnook1654483schnook
school11410723s_chool
shnook1366343s_hnook
shock144917033s__hock
shoo75929893s__hoo_
shooks134515633s__hooks
shool84523153s__hool
shoon84022013s__hoon
shoos84226363s__hoos
shoot84235913s__hoot
shylock1945053shylock
skidoo1136093skidoo_
skidoos1234463skidoos
skybox2242293sky_box
skydove1842083skydove
skyjack2242763skyjack
skylark1343273skylark
skyphoi1963013skyphoi
skyphos1963733skyphos
skywalk1642353skywalk
snook95115573s__nook
sonhood1168313sonhood
sook84933393s___ook
spook115416043s__pook
stook95218213s__took
strook10410303s_trook
unhook1347523_unhook

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit134027375.94022563.5
3Display Results37370.000 
 (SQL Overall)178691376.36028096.1
 
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.