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 “overcool” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
overcool137678(None) 
overcook1786151overcook
overcools1476771overcools
overboil1336912overboil
overbook1796322overbook
overcall1337672overcall
overcoat13312102overcoat
overcold14208492overcold
overcolor14134802overcolor
overcome151110702overcome
overcooks1875762overcooks
overcooled1646232overcooled
overcoy1536632overc_oy
overcrop1545772overcrop
overfoul1446222overfoul
overlook1596422overlook
oversoon1138302oversoon
oversoul1137092oversoul
overtoil1137452overtoil
overtook15106052overtook
novercal1345683noverc_al
overall10411083over_all
overbill1337283overbill
overblow1645033overblow
overboils1436623overboils
overbold14208553overbold
overbooks1855873overbooks
overbore131111583overbore
overborn13128703overborn
overcalls1447203overcalls
overcame151310693overcame
overcast132411973overcast
overchill1794213overchill
overcivil1743263overcivil
overclose1447013overclose
overcloud1544743overcloud
overcoach1944793overcoach
overcoats1438863overcoats
overcolors15124823overcolors
overcomer16127743overcomer
overcomes161110333overcomes
overcontrol1652593overcontrol
overcooked2044913overcooked
overcooling1746843overcooling
overcount1448323overcount
overcram1537073overcram
overcrops1646543overcrops
overcrowd1844583overcrowd
overcure132210053overcure
overcut12310423overc_ut
overcuts1337513overcuts
overdo10128363over_do_
overdoer12128713overdoer
overdoes121212543overdoes
overdog12106523over_dog
overdogs13127493overdogs
overdone121210913overdone
overdose121110063overdose
overfill1436313overfill
overflood1644523overflood
overflow1754923overflow
overfond1537323overfond
overfull1435923overfull
overgoad13127153overgoad
overgrow1544833overgrow
overhaul1436223overhaul
overhold15219013overhold
overholy17216673overholy
overhonor1543243overhonor
overhope1638343overhope
overhot13411223over_hot
overjoy2034873over_joy
overjoys2135183overjoys
overkill1535533overkill
overload12119283overload
overlong1238123overlong
overlooks1685483overlooks
overlord12119183overlord
overloud12117753overloud
overlove14239173overlove
overplot1338543overplot
overproof1745533overproof
overrode121810573overrode
overscore1447863overscore
oversell1137473oversell
overshoe1438563overshoe
overshoot1557133overshoot
overshot1449433overshot
overslow1435693overslow
oversoak1536993oversoak
oversoft1438843oversoft
oversold12218933oversold
oversouls1236603oversouls
overtoils1237083overtoils
overtone111012573overtone
overtop1237723over_top
overtops1338513overtops
overvote1438953overvote
overword15119243overword
overwore141111403overwore
overwork18118233overwork
overworn14118833overworn
overzeal2076093overzeal
precool1139013pre_cool
supercool1376523supercool
undercool1245533undercool

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621066.96620982.2
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.45223978.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.