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

200 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
liras5602198(None) 
liars54723161liars
libras83711701libras
limas75627631limas
lira46928681lira_
litas54923771litas
airns55521032airns
airs46447422air_s
airts55626342airts
alias55834602ali_as
aliyas93911802aliyas
arias55438022arias
arras55626132arras
auras55932552auras
bias64738152bi_as
bimas95521742bimas
birds85421332birds
birks114920302birks
birls74023162birls
biros75325132biros
birrs74917102birrs
boras75938302boras
bras65746452_bras
buras74736292buras
cires74932912cires
diram84419472diram
dirams94413702dirams
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
ditas65923672ditas
divas95418582divas
duras65727722duras
eras45441502_eras
eyras84715922eyras
fiars86720832fiars
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
flirs85518932flir_s
flirts95411482flirts
floras94715692floras
gigas75415582gigas
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
glias64618492gli_as
hijras1635772hijras
hires86134342hires
horas86333092horas
ires45639282_ires
iris45732542_iris
irks86220132_irks
kinas95626912kinas
kirks84915262kirks
kirns95315452kirns
kirs85831732kir_s
kivas124614732kivas
koras95927112koras
lairds74711612lairds
lairs55425872lair_s
lamas75532792lamas
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
larvas9310232larvas
las37281472l__as
lauras63414332lauras
lavas85422222lavas
lears55938732lears
leas45954182l_eas
lianas63713382lianas
liar47229682li_ar
liard65418592liard
liards75212612liards
libra74712422libra_
librae84310172librae
libs66732752li_bs
licks115325392licks
lidar6312722lidar
lidars7310782lidars
lidos65219882lidos
lids56336452li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
ligan67920282ligan
ligans76817732ligans
ligase7259912ligase
likes96231902likes
lilac7311072lilac
lilacs837482lilacs
lilos55821872lilos
lilts55822802lilts
lima65734132lima_
liman75921602liman
limans84816302limans
limbas105313192limbas
limbs96118932limbs
limes75636502limes
limns75718392limns
limos75320812limos
limpas105513082limpas
limps95522672limps
linac7315412linac
linacs8310812linacs
lines57054572lines
lingas75116562lingas
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lipa68425922lipa_
lipase8239102lipase
lips67141442li_ps
lire47845292lir_e
liri45128252lir_i
lirot5430032lirot
lis37162272li__s
lisps76913902lisps
lists56628692lists
litai55216362litai
litres65220392litres
lits46252492li_ts
lives86133192lives
livres94311862livres
loral55927822loral
loran55925092loran
lorans65117602lorans
lords64923502lords
lores55045402lores
loris55329152loris
lotas55926302lotas
lumas75622912lumas
lunas55025012lunas
lures56138532lures
lurks95218742lurks
lycras11287242lycras
lyres85019962lyres
maras75443282maras
mbiras1077142mbiras
micas96823052micas
minas75434112minas
mires75640882mires
mirks115122142mirks
mirs66940562mir_s
mirzas1738172mirzas
moras76438762moras
muras75329562muras
nairas6312772nairas
nipas77116672nipas
okras94410972okras
paras76143042paras
pias66542552pi_as
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pirns76020092pirns
pitas77427672pitas
ras37575392__ras
rias45540592ri_as
sikas94617022sikas
simas75727552simas
sires55945372sires
sirras63814862sirras
sirs44338332sir_s
soras55041012soras
suras55336322suras
tiaras6314532tiaras
tires55437492tires
tirls54519802tirls
tiros54524892tiros
toras55540372toras
ultras6310182ultras
varas86028192varas
vigas94817882vigas
vinas85126342vinas
viral86419592viral
vires84529682vires
virgas1048882virgas
virls85618602virls
virus85316842virus
visas84317652visas
vivas114815022vivas
wires86034912wires
yirds96612512yirds
yirrs8469192yirrs
ziram163912892ziram
zirams17438642zirams

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 Limit538002001.82629463.3
3Display Results2002000.0633174.6
 (SQL Overall)1786912001.98590020.7
 
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.