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

62 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
subcool114623(None) 
subcools1245751subcools
subcell1146752subcell
subcode1237162subcode
subcooled1444402subcooled
subgoal1046322subgoal
subsoil967292subsoil
uncool8610112_uncool
babool103012153bab_ool
cool66940493___cool
outcook1337203outcook
outfool1037333outfool
precool1139013precool
puccoon1343503puccoon
school11410723s_chool
scoop95617163s__coop
scoot75729153s__coot
scowl1012012973s__cowl
shool84523153s__hool
snool55118643s__nool
spool75219043s__pool
stool55619893s__tool
subatom1147053subatom
subcells1246283subcells
subclan1147173subclan
subcodes1338143subcodes
subcolony1643023subcolony
subconsul1352753subconsul
subcooling1544253subcooling
subcostal1344563subcostal
subcult1149603subcult
subdual10126713subdual
subecho1445073subecho_
subfloor13122903subfloor
subgoals1145553subgoals
subito8410453subito_
subjoin1645443subjoin
sublot82315523sub_lot
sublots92410913sublots
subnodal1145043subnodal
suboral92011993suboral
suborn8310013sub_orn
suboval12216723suboval
subplot1158133subplot
subsoils1076653subsoils
subtone9310343subtone
subtotal1046263subtotal
subvocal1544993subvocal
subworld1444193subworld
subzone1846993subzone
succor1036623su_ccor
succors1137413succors
succory1444643succory
succoth1445093succoth
succour1144693succour
sulcal8311273sulc_al
sunroof1047053sunroof
sunroom947013sunroom
supercool1376523supercool
surcoat9412923surcoat
uncoil8811853_uncoil
upcoil10126193_upcoil

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.390458182.1
2DLD Change Limit134027626.92319359.7
3Display Results62620.0302066.7
 (SQL Overall)178691627.34324334.9
 
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.