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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
hairy11531683(None) 
airy75734151_airy
dairy97016301dairy
fairy115318281fairy
hair76330141hair_
hairs86225171hairs
harry115322951harry
aery77231682_aery
air38058392_air_
airn46433832_airn
airs46447422_airs
airt45757782_airt
awry107619682_awry
bairn77515532bairn
caird85717232caird
cairn75717512cairn
cairny11557822cairny
carry105823782carry
chair105519632chair_
chairs114916172chairs
charry145012112charry
chary135023132cha_ry
daily95922332daily
daisy95915312daisy
diary95016972diary
faery116015482faery
fair76332522fair_
fairly125610012fairly
fairs85825442fairs
gaily95020972gaily
gharry13546272gharry
glairy10448272glairy
haar77323492haar_
haars85620472haars
haik115526982hai_k
haika125313792haika
haiks125120932haiks
haiku126113692haiku
hail74839062hai_l
hails85231642hails
haint85436322haint
hairdo1036432hairdo
haired105117172haired
hammy155113432hammy
handy125520872handy
hanky155418292hanky
haply135915062haply
happy155813532happy
hard85443502ha_rd
hardy125622062hardy
hare76255732ha_re
hark115237392ha_rk
harl75740002ha_rl
harm95637792ha_rm
harp96134282ha_rp
harpy136418202harpy
hart76865772ha_rt
hasty115718762hasty
hay97358772ha__y
hayey144812532hayey
hazily2179062hazily
hazy1918119192ha_zy
heir77523802heir_
heirs85618562heirs
henry114014472henry
herry114922472herry
hire75538962h_ire
hoary114516762hoary
hurry114917182hurry
kaury12429762kaury
lair45934152lair_
laird65417792laird
lairs55425872lairs
laity85318902laity
mair66133762mair_
mairs76228292mairs
marry104821692marry
miry96326742_miry
naira5314742naira
nairu5413812nairu
nary76931222na_ry
pair66031512pair_
pairs75325832pairs
parry105323752parry
rainy85921082rainy
saury84317222saury
shaird10288702shaird
shairn9269062shairn
spiry105017352spiry
tarry85422512tarry
thairm1156962thairm
vair75624142vair_
vairs85019132vairs
vary105226062va_ry
wair75830052wair_
wairs86424062wairs
wary106740012wa_ry
wiry106422832_wiry
yaird96111912yaird
zaire14311992zaire

Search took 4 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 Filter178691538000.186960704.3
2DLD Change Limit538001003.47015504.3
3Display Results1001000.0631587.3
 (SQL Overall)1786911003.71948048.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.