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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

243 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
hairs8622517(None) 
airs46447421_airs
chairs114916181chairs
fairs85825441fairs
haars85620471haars
haiks125120931haiks
hails85231641hails
hair76330141hair_
hairy115316831hairy
heirs85618561heirs
lairs55425871lairs
mairs76228301mairs
pairs75325831pairs
vairs85019131vairs
wairs86424061wairs
ahis76135382ahi_s
aids57846352_aids
ails45654712_ails
aims67738182_aims
ains46158882_ains
air38058392_air_
airn46433832_airn
airns55521032_airns
airt45757782_airt
airts55626342_airts
airy75734152_airy
ais39083572_ai_s
aits46355532_aits
amirs75924922amirs
ars37670932_a_rs
bails75933522bails
bairn77515532bairn
bairns86710872bairns
baits76630582baits
bars66564092ba_rs
caids85226422caids
cains75334302cains
caird85717232caird
cairds96411512cairds
cairn75717512cairn
cairns85313302cairns
carrs75730852carrs
cars67364762ca_rs
chains114819702chains
chair105519632chair_
chais107530312chai_s
charrs115219192charrs
chars105936642cha_rs
choirs114911882choirs
coirs75221052coirs
dairy97016302dairy
dais57040702dai_s
deairs74013782deairs
ears46356592ea_rs
emirs76116162emirs
fails85631482fails
fair76332522fair_
fairy115318282fairy
fakirs13468082fakirs
faqirs18456032faqirs
fiars86720832fiars
firs76637712_firs
flairs95711912flairs
flirs85518932flirs
gains65729512gains
gaits65726012gaits
gars55750742ga_rs
gaurs66317992gaurs
glairs75211332glairs
haafs115711162haafs
haar77323492haar_
habits113014652habits
habus106317142habus
hacks144928712hacks
hades96035112hades
haems105517012haems
haeres94017032haeres
haes77651022ha_es
haets86525122haets
hafts116219462hafts
hags86740842ha_gs
hahas117118442hahas
hahs108333362ha_hs
haik115526982hai_k
haika125313792haika
haiku126113692haiku
haikus13538292haikus
hail74839062hai_l
hailers104017262hailers
haint85436322haint
haints94417582haints
hairdo1036432hairdo
hairdos1136822hairdos
haired105117172haired
hajes155420942hajes
hajis156716282hajis
hakes126034302hakes
hakims1537302hakims
hakus125114112hakus
halers94926912halers
hales85449842hales
halids104016132halids
halls85633782halls
halms105225212halms
halos85230252halos
halts85230102halts
hames106138702hames
hams96446132ha_ms
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hants86335402hants
haps96443462ha_ps
hard85443502ha_rd
hards96435652hards
hare76255732ha_re
hares86255542hares
hark115237392ha_rk
harks126333432harks
harl75740002ha_rl
harls85634502harls
harm95637792ha_rm
harms106829012harms
harp96134292ha_rp
harps105926872harps
harry115322952harry
harsh116418052ha_rsh
hart76865772ha_rt
harts88441592harts
has67372652ha__s
hasps105114642hasps
haters94930402haters
hates86742572hates
hats76858252ha_ts
hauls86123732hauls
havers124721482havers
haves116034872haves
haviors1347382haviors
hawks155415702hawks
haws106439442ha_ws
hayers124415942hayers
hays106138072ha_ys
hazers184615952hazers
hazes174928322hazes
hears86737372hears
heils85222192heils
heir77523802heir_
hers75844872h_ers
hies74842832h_ies
hims95230972h_ims
hins76447992h_ins
hips96433702h_ips
hire75538962h_ire
hires86134342h_ires
his66359502h_i_s
hiss75629212h_iss
hits75545132h_its
hoars85925552hoars
hoers85724922hoers
hours85422392hours
jails125422942jails
jars117338352ja_rs
kafirs13306982kafirs
kaifs125715642kaifs
kails95525212kails
kains96125642kains
keirs95313672keirs
kirs85831732_kirs
laics76419252laics
lair45934152lair_
laird65417792laird
lairds74711612lairds
laris54737462laris
lars46956572la_rs
liars54723162liars
maars74621632maars
maids86327142maids
mails76037782mails
maims96321792maims
mains75635112mains
mair66133782mair_
mars66261872ma_rs
mirs66940572_mirs
mohairs1234952mohairs
nadirs7109002nadirs
naifs87617422naifs
nails55730402nails
naira5314742naira
nairas6312782nairas
nairu5413812nairu
nairus639142nairus
naris55735292naris
noirs55615462noirs
oars46846032oa_rs
paiks114719852paiks
pails75833062pails
pains75138282pains
pair66031512pair_
paris75145942paris
parrs75928672parrs
pars67560792pa_rs
qaids156116312qaids
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622rai_s
sabirs85414632sabirs
saids65328852saids
sails55738102sails
sains55639972sains
saris54544952saris
shaird10288702shaird
shairds11216262shairds
shairn9269062shairn
shairns10276782shairns
sirs44338332_sirs
stairs65416332stairs
stirs55921622stirs
tahrs85412332tahrs
tails55634192tails
tains54936322tains
tapirs84113172tapirs
tars46763952ta_rs
thairm1156962thairm
thairms1244452thairms
theirs94610352theirs
unhairs1036372unhairs
vails85825932vails
vair75624142vair_
vars75742072va_rs
waifs115719872waifs
wails86631482wails
wains86930872wains
wair75830052wair_
waits88333522waits
wars78659802wa_rs
weirs84316492weirs
whirs115218092whirs
yaird96111912yaird
yairds10448022yairds
zaire14311992zaire
zaires1539702zaires

Search took 2 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.0931921408.6
2DLD Change Limit538002431.67032215.6
3Display Results2432430.0633857.1
 (SQL Overall)1786912431.82697859.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.