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

61 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
heirdom134449(None) 
heirdoms1444351heirdoms
hairdo1036432hairdo_
hairdos1136822hairdos
heirloom1342732heirloom
sheikdom1842132sheikdom
weirdo10405882weirdo_
weirdos11355122weirdos
bedroom1247083bedroom
chefdom18134073che_fdom
chiefdom1942483chiefdom
czardom2144183czardom
dirdum1036033_dirdum
earldom1044583_earldom
eidos65817753_ei_dos
fiefdom1643013fiefdom
geekdom1542283geekdom
hairworm1644543hairworm
halidom1386443halidom
headroom1446303headroom
heard95222753heard__
heir77523803heir___
heired103813043heir_ed
heiress1036813heiress
heiring113312903heiring
heirlooms1442513heirlooms
heirs85618563heir__s
herd84933063he_rd__
herded114215643he_rded
herder104516463he_rder
herdic123112303he_rdic
herds96424683he_rd_s
hereof123212373he_reof
hereon93914363he_reon
heriot9422343he_riot
heritor10310563heritor
herm95636153he_r__m
hero74635783he_r_o_
heron85025503he_r_on
heros84930863he_r_os
legroom1076093legroom
peridot10514243peridot
regroom1077303regroom
seldom939413se_ldom
selfdom1343733selfdom
serfdom1344213serfdom
sheikdoms1941903sheikdoms
sheikhdom2251073sheikhdom
stardom1037763stardom
tearoom939063tearoom
tsardom1044483tsardom
tzardom1943733tzardom
weird95111283weird__
weirded1234513weirded
weirder1144923weirder
weirdie11224063weirdie
weirdly14274493weirdly
weirdoes12323833weirdoes
weirds10478053weird_s
weirdy13395463weird_y
wisdom1235983_wisdom

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.470380193.6
2DLD Change Limit134027616.75019855.9
3Display Results61610.0331848.5
 (SQL Overall)178691617.25324636.8
 
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.