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

239 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
fairs8582544(None) 
airs46447421_airs
fails85631481fails
fair76332521fair_
fairy115318281fairy
fakirs13468081fakirs
faqirs18456031faqirs
fiars86720831fiars
firs76637711f_irs
flairs95711911flairs
flirs85518931flirs
hairs86225171hairs
lairs55425871lairs
mairs76228301mairs
pairs75325831pairs
vairs85019131vairs
wairs86424061wairs
afars85716512afars
affairs1334162affairs
afire86215912afire
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
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
fabs98635862fa_bs
facers115519442facers
faces106439432faces
facias113415802facias
facies113921592facies
facts107021892facts
faders105117462faders
fades94932862fades
fados95620732fados
fads86939872fa_ds
faery116015482faery
fagins10513862fagins
fags86939122fa_gs
fail74840242fai_l
fain75840562fai_n
faint85837062faint
faints94818782faints
faired105915772faired
fairer95212062fairer
fairest10412292fairest
fairies103516042fairies
fairish1338992fairish
fairly125610012fairly
faith115620852faith
faiths124610272faiths
fakers134219532fakers
fakes126032482fakes
fakir125111492fakir_
falls85727652falls
fames105735922fames
fanes84639892fanes
fangs96224072fangs
fanos85926502fanos
fans76247372fa_ns
faqir17548642faqir_
faquirs1943862faquirs
far67762602fa_r_
fard85639062fa_rd
fards96629842fards
fare76354462fa_re
farers95924052farers
fares85852872fares
farl76338552fa_rl
farls85731112farls
farm95934532fa_rm
farms106324952farms
faro76136922fa_ro
faros85532022faros
fart76860562fa_rt
farts88336842farts
fas68262932fa__s
fasts86429682fasts
fates85139232fates
fats76252502fa_ts
fauns84516752fauns
favas115618592favas
faves115331422faves
favors124211402favors
favus114311732favus
fawns115914262fawns
faxes155726652faxes
fays108535362fa_ys
fazes175527212fazes
fears84829392fears
fiar76427332fiar_
fiats85324482fiats
fibs96329502f_ibs
fids87034742f_ids
figs85332642f_igs
fils75838692f_ils
fins75849092f_ins
fir66744892f_ir_
fire76245592f_ire
fires85740752f_ires
firm96026452f_irm
firms105217422f_irms
firn76927502f_irn
firns86018542f_irns
first86226122f_irst
fits76043462f_its
flails94313002flails
flair86114122flair_
flics105418362flics
fliers94417192fliers
flies85630712flies
flips105117742flips
flir76422202flir_
flirt87424752flirt
flirts95411482flirts
flits85625222flits
foils85025812foils
foins85523382foins
fours85521492fours
frails93716472frails
friars93812092friars
friers94718932friers
fries85535602fries
frigs96019272frigs
frits86129102frits
furs76735042f_urs
gains65729512gains
gaits65726012gaits
gars55750742ga_rs
gaurs66317992gaurs
glairs75211332glairs
haars85620472haars
haiks125120932haiks
hails85231642hails
hair76330142hair_
hairy115316832hairy
heirs85618562heirs
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
paiks114719852paiks
pails75833062pails
pains75138282pains
pair66031512pair_
paris75145942paris
parrs75928672parrs
pars67560792pa_rs
qaids156116312qaids
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622rai_s
sabirs85414632sabirs
saids65328852saids
sails55738102sails
sains55639972sains
saris54544952saris
sirs44338332_sirs
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 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.296603685.8
2DLD Change Limit538002391.48636204.6
3Display Results2392390.0603983.3
 (SQL Overall)1786912391.84297009.2
 
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.