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

71 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
hardtop134505(None) 
hardtops1444841hardtops
cartop104213562car_top
eardrop1065222eardrop
airdrop1044423airdrop
ardor64617863_ard_or
atop66124753_a__top
barhop13319643bar_hop
baryton1246003baryton
cardio9915673cardio_
cardon94120853card_on
cardoon104813813cardoon
carhop133610763car_hop
carton84522663car_ton
eardrops1165303eardrops
foretop12117893foretop
hadron102913753ha_dron
hagdon1188283hagd_on
hairdo1036433haird_o_
hairdos1136823haird_os
harbor11410723har_bor
hard85443503hard___
hardass1139753hardass
hardboot1446943hardboot
hardcore1446053hardcore
harden105718533hard_en
hardens113815023hardens
harder105022403hard_er
hardest113118413hardest
hardhat14411023hardhat
hardier114721543hardier
hardies114923233hardies
hardily143310273hardily
hardly135112833hard_ly
hardnose1245723hardnose
hardpan1336443hardpan
hards96435653hard__s
hardset113415833hardset
hardship1746043hardship
hardtack1843993hardtack
hardwood16155743hardwood
hardy125622063hard__y
harelip1245953harelip
haricot12311963haricot
harlot94422803har_lot
harlots103413293harlots
harp96134293har___p
harpoon1238313harpoon
harrow122610773har_row
hart76865773har_t__
hartal9415473har_tal
harts88441593har_t_s
hereto9313693hereto_
heritor10310563heritor
hightop1645013hightop
hilltop1244783hilltop
laptop1076813la_ptop
lardon74415063lard_on
lardoon83410373lardoon
madtom1138023ma_dtom
maintop1135143maintop
palmtop1343873palmtop
paradrop1344603paradrop
pardon94618733pard_on
parton84720993par_ton
ragtop936683ra_gtop
redtop937973_redtop
sartor6313883sar_tor
tardo65321103tard_o_
tardyon1134673tardyon
teardrop1153103teardrop

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 Limit134027716.61020276.4
3Display Results71710.0164437.5
 (SQL Overall)178691717.03225411.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.