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

137 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
haymow177368(None) 
haymows1883811haymows
hallow124818322hallow
harrow122610772harrow
aglow94711973_aglow
allow85420663_allow
alow75328593_a_low
ammo85520133_ammo_
ammos94815823_ammos
amok10217403_a_mok
anyhow1544103anyhow
armor75118053_armor
arrow83414883_arrow
avow107816463_a_vow
barlow112911423barlow
barrow114512763barrow
bayamo1335603bayamo_
bayamos1434663bayamos
bayman133712703bayman
baymen134212003baymen
bayou10512363bay_ou
cahow135110943ca_how
callow114714663callow
camo85731753ca_mo_
camos95927613ca_mos
cayman133613213cayman
cymol1287623_cymol
daemon9279593daemon
daimon9259713daimon
dayglow1541843dayglow
etymon1134693etymon
fallow124713853fallow
farrow12309973farrow
gammon1138903gammon
haboob1377883haboob
hadron102913753hadron
haem95730983haem__
haemal113811643haemal
haemic133210083haemic
haemin113412663haemin
haemoid1337203haemoid
haems105517013haem_s
hagdon1188283hagdon
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallows134417393hallows
halm95834973halm__
halma108219253halm_a
halmas117017893halmas
halms105225213halm_s
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
ham86363283ha_m__
hamal104623113ha_mal
hame97043133ha_m_e
hames106138703ha_mes
hammal134512063hammal
hammam12419333hammam
hammed144116973hammed
hammer138120033hammer
hammock2064633hammock
hammy155113433ha_mmy
hams96446133ha_m_s
hamza19139773ha_mza
hansom11219153hansom
hao67251123ha__o_
harbor11410723harbor
harlot94422803harlot
harm95637793harm__
harmed125218833harmed
harmer114719553harmer
harmin113117393harmin
harmony1538173harmony
harms106829013harm_s
harrows132611033harrows
hatbox1835133hatbox
havior1248203havior
havoc1337183ha_voc
haw97153273ha___w
hay97358773hay___
haycock2144313haycock
hayed125822013hay_ed
hayer114620243hay_er
hayers124415943hayers
hayey144812533hay_ey
hayfork2043763hayfork
haying134420613haying
hayloft1696963hayloft
hays106138073hay__s
hazmat20312263hazmat
hollow124212663hollow
hommos13128503hommos
homo96126473h_omo_
homos105921783h_omos
how97252433h___ow
humor101110513h_umor
hymen13311043h_ymen
hymn12311313h_ym_n
hymns1337523h_ymns
hypo127516353h_ypo_
hypos1312014743h_ypos
hyson1138693h_yson
kayo116417553kay_o_
kayos127714703kay_os
layman113511303layman
laymen113010843laymen
mallow114014743mallow
mammon939643mammon
marmot10318743marmot
marrow112812603marrow
mayo96524303may_o_
mayor106616623may_or
mayos105521933may_os
maypop1565143maypop
mow86650353___mow
narrow9269143narrow
payor105413843pay_or
rayon83815703ray_on
sallow94315753sallow
salmon84614183salmon
shadow1337253sha_dow
shallow13388873shallow
shammos14307203shammos
shamos114216983sha_mos
shamoy14379913sha_moy
tallow93714203tallow
thymol1434463thymol
wadmol1234053wadmol
wallow123913513wallow
whammo16405193whammo_
whamo135511263wha_mo_
yarrow12287933yarrow
yow96945293__y_ow

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161374.76623650.0
3Display Results1371370.0304566.7
 (SQL Overall)1786911375.17234549.7
 
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.