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

51 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
hardwire154462(None) 
hardware1546281hardware
hardwired1742871hardwired
hardwires1644641hardwires
barbwire1543862barbwire
hardcore1446042hardcore
hardier114721542hard_ier
hardline12310272hardline
hardwares1646562hardwares
haywire1644742ha_ywire
admire949933_a_dmire
armoire938133_armoire
barbwires1643643barbwires
barware12610703bar_ware
cardiae10713703card_iae
farmwife1942173farmwife
handier113817443hand_ier
handlike1639153handlike
handwork1946903handwork
handwrit1547243handwrit
handwrite1645143handwrite
hangfire1543763hangfire
hardcase1445623hardcase
hardcores1545973hardcores
hardedge1442923hardedge
hardener1238883hardener
harder105022403hard_er_
hardies114923233hard_ies
hardily143310273hard_ily
hardnose1245723hardnose
hardwiring1842223hardwiring
hardwood16155743hardwood
harelike1539613harelike
harmine122816193har_mine
harrier104417753har_rier
haywires1744043ha_ywires
herdlike1636113herdlike
lardier83518343lard_ier
lardlike1336503lardlike
nardine82712573nard_ine
pardie96021443pard_i_e
pardine103616723pard_ine
prewire124311143_prewire
rewire95421413__rewire
sardine83317393sard_ine
shareware1544333shareware
tardier859719993tard_ier
tardive1136893tard_ive
warpwise1642853warpwise
yardbird1542323yardbird
yardwork1944513yardwork

Search took 9 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.423422437.4
2DLD Change Limit146162517.76618820.8
3Display Results51510.0163187.5
 (SQL Overall)178691518.20521778.3
 
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.