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

227 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
hirer8542312(None) 
airer54927891airer
direr64927071direr
firer811229251firer
hider95024081hider
hiker125119391hiker
hire75538961hire_
hired95226261hired
hiree85427801hiree
hirers94518061hirers
hires86134341hires
wirer85124951wirer
aider65431132aider
aimer75926822aimer
aired66032922aired
airers64922312airers
airier64619362airier
aiver85725162aiver
barer74535802barer
bider85728372bider
bier65531832bi_er
biker116022562biker
biner75930692biner
birder94915492birder
birler85715082birler
birr66022362bir_r
biter75030032biter
borer75131272borer
brier74527402brier
carer74942332carer
chicer134513602chicer
chider125116052chider
chimer135517202chimer
chirker16429322chirker
chirper14359962chirper
chirr105015902chir_r
chirre114111852chirre
cider84723312cider
cire65836372cire_
cires74932912cires
citer74827332citer
corer75538872corer
crier74724462crier
curer75030752curer
darer65230792darer
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire_
diver94827802diver
drier64423962drier
eider64624742eider
fairer95212062fairer
farer86733142farer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
fire76245592fire_
fired94829742fired
firers94922682firers
fires85740752fires
firmer114712442firmer
fiver116024942fiver
fixer154717832fixer
frier85225842frier
giber85417702giber
girder84312062girder
giver94921202giver
hailer94720342hailer
haired105117172haired
hairier103111052hairier
haler85033522haler
harder105022402harder
hare76255732hare_
hared95742182hared
harem104924452harem
hares86255542hares
harmer114719552harmer
harper115018402harper
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
hearer94323652hearer
heder95623642heder
heifer1238202heifer
heired103813042heired
her66547812h__er
herder104516462herder
here76447102here_
heres86245902heres
hewer115719932hewer
hexer155116682hexer
hide85134642hide_
hided105222442hided
hiders104919652hiders
hides95129422hides
hie67652702hi_e_
hied85434042hi_ed
hies74842832hi_es
higher134610892higher
hike116830392hike_
hiked135919202hiked
hikers135014352hikers
hikes125426982hikes
hilar85418142hilar
hiller94421632hiller
hinder104120062hinder
hinger104723332hinger
hinter94021302hinter
hipper133818022hipper
hirees95117292hirees
hirsel9138682hirsel
hisser94713792hisser
hither124417252hither
hitter94419862hitter
hive106029672hive_
hived125217912hived
hives116925512hives
hoer76533982h_oer
homer105828452homer
honer85332092honer
hoper105829142hoper
hoser811529762hoser
hover115524132hover
huger94914872huger
hurler94717222hurler
hurter93915852hurter
hyper135213902hyper
ire36943172_ire_
ired55131872_ired
ires45639282_ires
jiber145115702jiber
jiver155119052jiver
kier86526812ki_er
kiter95523212kiter
liber74723622liber
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
lire47845292lire_
liter54736342liter
liver85132962liver
lurer54625312lurer
merer75126232merer
miler75733062miler
mimer94825762mimer
miner76933542miner
mire66748232mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918362mirier
mirker123712692mirker
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
niter55028972niter
oiler54628282oiler
parer75839902parer
pier66035292pi_er
piker115622842piker
piper96523192piper
prier75027762prier
purer75127902purer
rarer54731702rarer
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
serer55935512serer
sharer95025482sharer
shier85428942shi_er
shiner93820872shiner
shire84727132shire_
shires95225572shires
shirker143711342shirker
shirr84716922shir_r
shiver124517372shiver
siker95326032siker
sire46150412sire_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
siver85728612siver
sizer145521812sizer
sorer56236592sorer
surer54833102surer
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tire46143352tire_
tired65228902tired
tires55437492tires
titer55430612titer
trier54328532trier
vier75428152vi_er
viler86324162viler
viper105017302viper
vireo84816452vireo
vires84529682vires
whiner124516632whiner
whirler13307602whirler
whirr114611192whir_r
whiter124316392whiter
wider94826352wider
wiper105421292wiper
wire75839812wire_
wired95327642wired
wirers94617892wirers
wires86034912wires
wirier94215552wirier
wiser85522802wiser
wiver115924512wiver
wrier84521752wrier
yarer84321572yarer
yirr76513572yir_r

Search took 5 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.610292936.1
2DLD Change Limit538002273.26616472.7
3Display Results2272270.1401621.4
 (SQL Overall)1786912274.01644494.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.