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

54 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
sorgho10348711sorgho_
sorghos11327601sorghos
forgot104318132forg_ot
sorghum1343512sorghum
sorgo64719722sorg_o_
sorgos74514662sorg_os
sought106315052sough_t
airshot1059493airshot
argot67728653_arg_ot
borsht11813503borsh_t
boughpot1643503boughpot
bought125115633bough_t
bowshot1578253bowshot
dought114915513dough_t
earshot10410823earshot
ergot65422893_erg_ot
forgat104018583forg_at
forget106326393forg_et
forgo94418333forg_o_
fought135112393fough_t
gorget87123863gorg_et
gorgon8310243gorg_on
hotshot1358343hotshot
lorgnon844423lorgnon
morpho13158443morpho_
morphos14159083morphos
nought104713963nough_t
orgeat7515033_orgeat
ortho8312293_ortho_
ought95221533_ough_t
potshot1249733potshot
sargo65424413sarg_o_
sargos74318273sarg_os
shot76150263s___hot
sight94629293s_igh_t
slight103416003sligh_t
somehow1543663somehow
soot45761063so___ot
sorbent92915243sorbent
sorbet83924083sor_bet
sordor7310223sor_dor
sorest65028003sor_est
sorghums1442633sorghums
sorrow9339443sor_row
sort46264813sor___t
sough95320463sough__
soughed123811623soughed
soughs105115623sough_s
sovkhoz2642093sovkhoz
spigot9312603spig_ot
spright132010403sprigh_t
surgeon837003surgeon
torchon1237363torchon
torot56139943tor__ot

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 Filter1786911340270.406440125.6
2DLD Change Limit134027546.92019368.1
3Display Results54540.0331636.4
 (SQL Overall)178691547.35924282.0
 
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.