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

195 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
fiars8672083(None) 
fairs85825441fairs
fears84829391fears
fiar76427331fiar_
fiats85324481fiats
firs76637711fi_rs
friars93812091friars
liars54723161liars
afars85716512afars
agars66120642agars
airs46447422ai_rs
ars37670932__ars
bars66564092_bars
bears75739042bears
bias64738152bia_s
biers76225222biers
birrs74917102birrs
boars75229602boars
briars84814822briars
cars67364762_cars
chars105936632chars
cigars9910712cigars
czars164812912czars
dears65736882dears
dials64925342dials
diary95016972diary
dinars75417562dinars
ears46356592_ears
fabs98635862f_abs
fads86939872f_ads
fags86939122f_ags
fails85631482fails
fair76332522fair_
fairy115318282fairy
fans76247362f_ans
far67762602f_ar_
fard85639062f_ard
fards96629842f_ards
fare76354462f_are
fares85852872f_ares
farl76338552f_arl
farls85731112f_arls
farm95934532f_arm
farms106324952f_arms
faro76136922f_aro
faros85532022f_aros
fart76860562f_art
farts88336842f_arts
fas68262932f_a_s
fats76252502f_ats
fays108535362f_ays
fear75337792fear_
feats86432752feats
feuars938652feuars
fiacre1137622fiacre
fiacres1237252fiacres
fiat76646642fia_t
fibers114717522fibers
fibre104812842fibre
fibres114312122fibres
fibs96329492fi_bs
fices106031162fices
ficus105015492ficus
fidos95819052fidos
fids87034732fi_ds
fiefs116213702fiefs
fiery114714792fiery
fifers125414922fifers
fifes114822392fifes
figs85332642fi_gs
filar84819292filar_
filers94623722filers
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fi_ls
finals94316162finals
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fi_ns
fiord94313342fiord
fiords10498622fiords
fir66744892fi_r_
fire76245592fi_re
firers94922682firers
fires85740752fires
firm96026452fi_rm
firms105217422firms
firn76927502fi_rn
firns86018542firns
firry115713532firry
first86226122fi_rst
fiscs105311882fiscs
fists85527542fists
fits76043462fi_ts
fivers124420922fivers
fives116027362fives
fixers165112982fixers
fixes154723592fixes
flabs105818642flabs
flags95321282flags
flairs95711912flairs
flams105125012flams
flans85327972flans
flaps105621382flaps
flare84823632flare
flares94521702flares
flats86429742flats
flaws115920342flaws
flays116321052flays
fliers94417192fliers
flirs85518932flirs
foals85721692foals
foams105017952foams
fours85521492fours
frags96322162frags
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
friar85414272friar_
friary124010092friary
friers94718932friers
furs76735042f_urs
gars55750742_gars
gears64628692gears
gnars66718852gnars
guars65021042guars
haars85620472haars
hairs86225172hairs
hears86737372hears
hoars85925542hoars
izars145112932izars
jars117338352_jars
kbars114612602kbars
kiers95320092kiers
kirs85831732ki_rs
knars94416112knars
kyars124813962kyars
lairs55425872lairs
lars46956572_lars
lears55938732lears
liar47229682liar_
liard65418592liard
liards75212612liards
lidars7310782lidars
liers55130402liers
liras56021982liras
maars74621632maars
mairs76228292mairs
mars66261862_mars
mirs66940562mi_rs
nears55529422nears
oars46846032_oars
pairs75325832pairs
pars67560792_pars
pears75138612pears
pians75126962pians
pias66542552pia_s
piers75926332piers
rears54739652rears
rials55026672rials
rias45540592ria_s
roars55622232roars
scars75433532scars
sears54744912sears
sials54227242sials
simars84916932simars
sirs44338332si_rs
sitars65417592sitars
sizars154812622sizars
soars54732512soars
spars75431542spars
stars55836572stars
tars46763952_tars
tears55436462tears
tiara5315902tiara
tiaras6314532tiaras
tiers55526522tiers
tsars56717102tsars
tzars144914272tzars
vairs85019132vairs
vars75742072_vars
vials85822382vials
vicars11712262vicars
viers85621952viers
wairs86424062wairs
wars78659802_wars
wears86030302wears
years84527672years
yirrs8469192yirrs

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.0961861364.6
2DLD Change Limit538001951.92028020.8
3Display Results1951950.0633095.2
 (SQL Overall)1786911952.07985950.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.