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

169 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
heirs8561856(None) 
hairs86225171hairs
hears86737371hears
heils85222191heils
heir77523801heir_
hers75844871he_rs
keirs95313681keirs
theirs94610351theirs
weirs84316491weirs
airs46447432_airs
amirs75924922amirs
bears75739042bears
beers75628392beers
biers76225222biers
ceils75019402ceils
chairs114916182chairs
cheers114518912cheers
choirs114911882choirs
coheirs1236752coheirs
coirs75221052coirs
deairs74013782deairs
dears65736882dears
deers64930522deers
deils65722862deils
ears46356592_ears
emirs76116162emirs
errs45622532_errs
ers36046282_e_rs
fairs85825442fairs
fears84829392fears
firs76637722_firs
flirs85518932flirs
gears64628692gears
haars85620472haars
haiks125120932haiks
hails85231642hails
hair76330142hair_
hairy115316832hairy
heads95127112heads
heals85733462heals
heaps105223222heaps
hear76143882hear_
heard95222752heard
hearse94114282hearse
heart85440742heart
hearts96218942hearts
heats85838402heats
hebes105521672hebes
hecks145220652hecks
heders104119762heders
heeds95420422heeds
heels85625532heels
hefts116218152hefts
hegira1036522hegira
hegiras1136102hegiras
hehs106723962he_hs
heifers1337932heifers
heigh124812542heigh
heil76328932hei_l
heired103813042heired
heiress1036812heiress
heist87030912heist
heists96814632heists
hejira1644802hejira
hejiras1744232hejiras
helios94816632helios
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
hemes105031082hemes
hemins113417572hemins
hemps126917332hemps
hems95534942he_ms
henry114014472henry
henrys12366102henrys
hens75642572he_ns
hents87330742hents
her66547812he_r_
herb94730962he_rb
herbs105520502herbs
herd84933062he_rd
herds96424682herds
here76447102he_re
heres86245902heres
herl75834552he_rl
herls85226432herls
herm95636152he_rm
herms105626432herms
hern76134892he_rn
herns84825582herns
hero74635782he_ro
heros84930862heros
herry114922472herry
hes66654202he__s
hests85829932hests
heths116317782heths
hets75547202he_ts
hewers123715272hewers
hews105631572he_ws
hexers165612752hexers
hexes155123042hexes
hies74842842h_ies
hims95230982h_ims
hins76448002h_ins
hips96433712h_ips
hire75538972h_ire
hires86134342h_ires
his66359512h_i_s
hiss75629222h_iss
hits75545142h_its
hoars85925552hoars
hoers85724922hoers
hours85422392hours
jeers124818132jeers
kefirs13396652kefirs
keir86217882keir_
kiers95320102kiers
kirs85831752_kirs
lairs55425872lairs
lears55938732lears
leers54828982leers
lehrs86111132lehrs
leis45739602lei_s
liers55130402liers
mairs76228302mairs
mirs66940582_mirs
nears55529422nears
neifs85613042neifs
noirs55615462noirs
pairs75325832pairs
pears75138612pears
peers75130272peers
peins76128062peins
peris75537072peris
piers75926332piers
rears54739652rears
reifs84819092reifs
reins56234562reins
reis45343232rei_s
sears54744912sears
seers55136382seers
seifs85019332seifs
seis45542392sei_s
sers45746652se_rs
shears93820902shears
sheers94322402sheers
sheiks132510012sheiks
shiers94921752shiers
sirs44338342_sirs
speirs85013232speirs
stirs55921622stirs
tears55436462tears
theins95015422theins
their85512152their_
tiers55526522tiers
vairs85019132vairs
veers84521362veers
veils84918802veils
veins84620492veins
viers85621952viers
wairs86424062wairs
wears86030302wears
weir76019922weir_
weird95111282weird
weirds10478052weirds
whirs115218092whirs
years84527672years
zeins144715392zeins

Search took 3 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.360496363.9
2DLD Change Limit538001691.69031834.3
3Display Results1691690.0463673.9
 (SQL Overall)1786911692.09685253.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.