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

86 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
surcoat941292(None) 
surcoats1047941surcoats
sugarcoat1253692sugarcoat
surfboat1345332surfboat
surtout7411672surtout
turncoat1044852turncoat
airboat9512133airboat
bluecoat1244493bluecoat
bumboat1349023bumboat
burbot10815653burbo_t
burgout1049773burgout
burnout9310453burnout
coat67558353___coat
curacoa1146223curacoa_
curacoas1246033curacoas
ducat86225903du_c_at
furcate12310453furc_ate
groat65531973_gr_oat
gunboat1047363gunboat
jurat124829323jur__at
mudcat11311203mudc_at
muscat10314653musc_at
outercoat1146273outercoat
overcoat13312103overcoat
peacoat11412913peacoat
purport1159393purport
recoat84024273_recoat
redcoat10410883redcoat
sarcoid10310453sarcoid
sarcoma1147403sarcoma
sarcomas1247223sarcomas
sarcomata1344803sarcomata
sarcous9312933sarcous
scat65848373s__c_at
scoot75729153s__coot
scot66242613s__co_t
scout75031453s__cout
scrota8310203scr_ota
seacoast1047783seacoast
shoat85633953s__hoat
sprat76635973spr__at
sprout8419403spr_out
stoat57135953s__toat
subclan1147173subclan
subcode1237163subcode
subcool1146233subcool
subcult1149603subcult
subgoal1046323subgoal
sublot82315523sublo_t
succah1336643su_ccah
succor1036623succo_r
succors1137413succors
succory1444643succory
succoth1445093succoth
succour1144693succour
sucrose939303sucrose
sugarcoats1352383sugarcoats
sukkot936643sukko_t
sulcal8311273sulc_al
sulcate9314423sulc_ate
support11310523support
sura45740293sur__a_
surah86823253sur__ah
sural55931263sur__al
suras55336333sur__as
surcease1086883surcease
surest65026763sur_est
surfboats1443563surfboats
surfeit10310343surfeit
surfman1236203surfman
suricate10312613suricate
surmount1045903surmount
surra55521343sur_ra_
surras65919533sur_ras
surreal739233surreal
surrogate1044783surrogate
surroyal1143953surroyal
surtax1337843sur_tax
surtouts846203surtouts
throat94819753thr_oat
topcoat1179313topcoat
tugboat10126103tugboat
turbot8914263turbo_t
turncoats1143013turncoats
turnout7410283turnout
upcoast1165543_upcoast

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.390458182.1
2DLD Change Limit134027865.86022871.5
3Display Results86860.0302866.7
 (SQL Overall)178691866.28028454.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.