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 “loris” 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
loris5532915(None) 
laris54737461laris
lords64923501lords
lores55045401lores
lories64933041lories
louis57322321louis
noris54928271noris
zoris145320011zoris
abris75722602abris
aorist64827872aorist
arris56824682arris
auris55331522auris
boras75938302boras
bores76448252bores
boric98024222boric
borks115727702borks
borts76735452borts
bris65539612_bris
coirs75221052coirs
cords86030622cords
cores76361852cores
corgis9314402corgis
coria75828302coria
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
cris66233432_cris
dories75232362dories
dorks105724442dorks
dorms85723832dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
floras94715692floras
florid10311452florid
florin9312652florin
florins10311642florins
florist10314242florist
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
fortis95418612fortis
forts86034452forts
gloria71910542gloria
glorias81610312glorias
glories81915912glories
gores65740372gores
gorms85619592gorms
gorps85316992gorps
horas86333092horas
horns86125332horns
houris94514562houris
iris45732542_iris
kois85129392ko_is
kojis16468432kojis
koras95927112koras
kors85933012kor_s
kris86423602_kris
lairs55425872lairs
lapis76223152lapis
lards65331862lards
lares54852632lares
lari45839152lari_
larks95227812larks
lars46956572lar_s
leis45739602l_eis
lenis56326862lenis
levis85818552levis
lewis85315842lewis
lexis125916032lexis
liras56021982liras
liri45128252liri_
lis37162272l__is
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lobes75331002lobes
lobos75921842lobos
lobs66441082lo_bs
lochs106715512lochs
loci66126282loci_
locks115126922locks
locos75822602locos
locus74819992locus
lodes66436912lodes
loess55714702loess
lofts85518362lofts
loges66534202loges
logia68116602logia
logic88217832logic
logics95711122logics
login66025002login
logins77820642logins
logos67225332logos
logs57343112lo_gs
loid55531482lo_id
loids66220702loids
loin46838722lo_in
loins56728422loins
lolls512121732lolls
longs65527062longs
loofs85623782loofs
looie55624242looie
looies65025832looies
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122lo_os
loots55431422loots
lopes76437342lopes
lops66043352lo_ps
loral55927822loral
loran55925092loran
lorans65117602lorans
lord55032082lor_d
lore45850352lor_e
lorica8310442lorica
lorises73918592lorises
lorn46435252lor_n
lorries74518342lorries
lorry86315662lorry
lory75931712lor_y
loses56742012loses
loss45337962lo_ss
lotas55926302lotas
loti46431832loti_
lotic76420662lotic
lotos54724632lotos
lots47652092lo_ts
lotus55718062lotus
louie55023512louie
louies64525102louies
loups75319622loups
lours55125292lours
louts56330272louts
loves85332012loves
lowes85732462lowes
lowish12310532lowish
lows75843012lo_ws
loxes125227472loxes
lures56138532lures
lurid64618972lurid
lurks95218742lurks
lweis8458692lweis
lyres85019962lyres
lyric104512722lyric
lyrics11357942lyrics
lyrism1137472lyrism
lyrist9312292lyrist
lysis84511462lysis
moras76438762moras
mores76249642mores
morns75527442morns
morris83814722morris
mors65950062mor_s
morts75533562morts
naris55735292naris
noirs55615462noirs
nori47133142nori_
noria55722182noria
norias65518182norias
norms76019302norms
obis66226832_obis
oorie53026362oorie
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ornis54616772_ornis
orris54516552orris
ors35750112_or_s
orts46538332_orts
paris75145942paris
peris75537072peris
pois66539042po_is
polis74731162polis
pooris83916842pooris
pores75849032pores
porism104518062porism
porks115124142porks
porns75527342porns
ports75934592ports
puris75332022puris
rotis56327052rotis
saris54544952saris
shris84221442shris
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sori46039832sori_
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
sris45434152_sris
topis76025832topis
toras55540372toras
torcs75123762torcs
tores55352672tores
tori47542152tori_
toric76529312toric
torics85118352torics
tories65435882tories
torii55521592torii
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torsi57423362torsi
torts56138122torts
torus54329762torus
trois57226092trois
tsoris63411192tsoris
words95425072words
works125621902works
worms105320752worms
worts88631182worts
yogis95617742yogis
yonis85020822yonis
yores85031322yores
zori137722922zori_
zoril143916692zoril
zorils153810882zorils

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.313570897.8
2DLD Change Limit538002273.89013830.3
3Display Results2272270.0962364.6
 (SQL Overall)1786912274.29941565.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.