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

257 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
pairs7532583(None) 
airs46447421_airs
fairs85825441fairs
hairs86225171hairs
lairs55425871lairs
mairs76228301mairs
paiks114719851paiks
pails75833061pails
pains75138281pains
pair66031511pair_
paris75145941paris
parrs75928671parrs
pars67560791pa_rs
vairs85019131vairs
wairs86424061wairs
aids57846362_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
apers76629132apers
ars37670932_a_rs
bails75933522bails
bairn77515532bairn
bairns86710872bairns
baits76630582baits
bars66564092ba_rs
caids85226422caids
cains75334302cains
caird85717232caird
cairds96411512cairds
cairn75717512cairn
cairns85313302cairns
carrs75730852carrs
cars67364762ca_rs
chairs114916182chairs
coirs75221052coirs
dairy97016302dairy
dais57040702dai_s
deairs74013782deairs
ears46356592ea_rs
emirs76116162emirs
fails85631482fails
fair76332522fair_
fairy115318282fairy
fakirs13468082fakirs
faqirs18456032faqirs
fiars86720832fiars
firs76637712_firs
flairs95711912flairs
flirs85518932flirs
gains65729512gains
gaits65726012gaits
gars55750742ga_rs
gaurs66317992gaurs
glairs75211332glairs
haars85620472haars
haiks125120932haiks
hails85231642hails
hair76330142hair_
hairy115316832hairy
heirs85618562heirs
impairs1135822impairs
jails125422942jails
jars117338352ja_rs
kafirs13306982kafirs
kaifs125715642kaifs
kails95525212kails
kains96125642kains
keirs95313672keirs
kirs85831742_kirs
laics76419252laics
lair45934152lair_
laird65417792laird
lairds74711612lairds
laris54737462laris
lars46956572la_rs
liars54723162liars
maars74621632maars
maids86327142maids
mails76037782mails
maims96321792maims
mains75635112mains
mair66133782mair_
mars66261872ma_rs
mirs66940572_mirs
nadirs7109002nadirs
naifs87617422naifs
nails55730402nails
naira5314742naira
nairas6312782nairas
nairu5413812nairu
nairus639142nairus
naris55735292naris
noirs55615462noirs
oars46846032oa_rs
pacas96029402pacas
pacers105124542pacers
paces96741112paces
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
padis86227142padis
padre86018162padre
padres95016982padres
padri85815172padri
pads76742952pa_ds
pagers94423252pagers
pages85235072pages
paid75737482pai_d
paik105726802pai_k
pail66141832pai_l
pain65647242pai_n
paint75443692paint
paints85921832paints
paired95017522paired
paisa76021072paisa
paisas84317492paisas
paise75028332paise
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
panes76148692panes
pangs84628662pangs
panics103815362panics
paniers94717332paniers
pans65855732pa_ns
pants76536922pants
papas94927492papas
papers105125322papers
paps86443452pa_ps
par57467022pa_r_
para65242172pa_ra
paras76143042paras
pard76441322pa_rd
pards85634332pards
pare66760842pa_re
parers85530742parers
pares77164482pares
paries84742512paries
parish115022352parish
park105237492pa_rk
parks116134462parks
parr65731152pa_rr
parry105323752parry
parse75236992pa_rse
part65967462pa_rt
parts77743372parts
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
pasts75936502pasts
paters84935832paters
pates76047892pates
paths105521382paths
patins87528782patins
patios85221782patios
pats66460852pa_ts
pavers115021822pavers
paves104833922paves
pavins114919662pavins
paviors1237602paviors
pavis106422732pavis
pawers114818782pawers
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
payers114621822payers
payors114312642payors
pays95940222pa_ys
pears75138612pears
peers75130272peers
peins76128062peins
peris75537072peris
phis95724902phi_s
pians75126962pians
pias66542552p_ias
pics85633912p_ics
piers75926332piers
pies66949602p_ies
pigs76634222p_igs
pins65558452p_ins
pips85837132p_ips
pirn67128372p_irn
pirns76020092p_irns
pis56362032p_i_s
piss65033332p_iss
pits66348742p_its
plaids94312442plaids
plains85019592plains
plaits83816472plaits
pliers84715152pliers
plies74526512plies
pois66539042poi_s
pours74623182pours
priers84521192priers
pries74339532pries
prigs85219702prigs
prims95425932prims
priors83914482priors
priss74623892priss
psis68120342psi_s
puris75332022puris
purrs75320432purrs
purs65641042p_urs
pyins105815862pyins
qaids156116312qaids
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622rai_s
repairs9319972repairs
sabirs85414632sabirs
saids65328852saids
sails55738102sails
sains55639972sains
saris54544952saris
sirs44338332_sirs
spails84817822spails
spaits85017472spaits
spars75431542spa_rs
speirs85013232speirs
stairs65416332stairs
stirs55921622stirs
tahrs85412332tahrs
tails55634192tails
tains54936322tains
tapirs84113172tapirs
tars46763952ta_rs
vails85825932vails
vair75624142vair_
vars75742072va_rs
waifs115719872waifs
wails86631482wails
wains86930872wains
wair75830052wair_
waits88333522waits
wars78659802wa_rs
weirs84316492weirs
whirs115218092whirs
yaird96111912yaird
yairds10448022yairds
zaire14311992zaire
zaires1539702zaires

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.656272394.8
2DLD Change Limit538002573.33016156.2
3Display Results2572570.1232089.4
 (SQL Overall)1786912574.10943487.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.